Hi,
I am building a rollup table for accounts where some accounts have up to 6 categorizations and others have as little as 3. If I have a column for the 6th level of granularity subcategory, how do I treat those accounts that do not have that level of a subcategory? Should I just put in a placeholder (ex: repeat the lowest level of granularity subcategory available)? Or is it better to leave null?
Thank you!
submitted by /u/businessi1
[link] [comments]
Go to Source of this post
Author Of this post: /u/businessi1
Title Of post: Proper way to treat rollup subcategories
Author Link: {authorlink}