Hey guys, I need some help understanding how to write customized multi-level subtotals (ideally) in Pivot tables. The levels are like this...
0 Level: Retail Stores
1st Level: Districts
2nd Level: Markets
3rd Level: Regions
4th Level Company
The subtotal will need to account for positive numbers on the zero level and first level and ignore positive numbers on the second level and above. The addition can only add up the sum of levels and not from the ground level (0). Is there any way to do this? The report is updated twice a week and we have constant hierarchy changes. Currently, this is managed with Subtotals, but it's a huge headache.
Any suggestions will be much appreciated! Even if just to help me confirm that this is not something we can do in PowerPivot using DAX.
T
0 Level: Retail Stores
1st Level: Districts
2nd Level: Markets
3rd Level: Regions
4th Level Company
The subtotal will need to account for positive numbers on the zero level and first level and ignore positive numbers on the second level and above. The addition can only add up the sum of levels and not from the ground level (0). Is there any way to do this? The report is updated twice a week and we have constant hierarchy changes. Currently, this is managed with Subtotals, but it's a huge headache.
Any suggestions will be much appreciated! Even if just to help me confirm that this is not something we can do in PowerPivot using DAX.
T
