Michael Springer on 30 Dec 2016 03:16:08
Is there an easier way to roll-up data when filtering down to more specific data points? For instance, if I choose a store in my report, I would like to see sales for that store but then the parent category's sales as, say, the region, then division, then chain. This way I can identify how a product or store is performing as compared to it's "peers." The only way I could think to do this now is to create additional data points in my data model to show what those totals are for each child class but this could obviously explode my data size.