Customized subtotal in PowerPivot

tamtammg

New Member
Joined
Oct 15, 2020
Messages
8
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
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Forum statistics

Threads
1,226,730
Messages
6,192,705
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top