Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have pivot table, and I can show subtotals for countries after each country but the client wants to have subtotals at the end of the table like in the image. The table is always fully expanded,and the number of countries and regions can be variable. Also The text for countries subtotal can be customized.
Thank you all for your help in advance.
The solution is to create dummy dimension and then for used dimensions in pivot table to use:
- for country : =if (DummyDim<>1, 'SubTotal', pick(DummyDim,Country))
- for region: =if(DummyDim=1, RegionName, Country)
this is the result:
The solution is to create dummy dimension and then for used dimensions in pivot table to use:
- for country : =if (DummyDim<>1, 'SubTotal', pick(DummyDim,Country))
- for region: =if(DummyDim=1, RegionName, Country)
this is the result: