I don't know what is the specific requirement here.Usually higher level nodes in hierarchy shows summed up all lower level values.
Here the requirement is to show Subtotal values in the Pivot table on Hierarchy columns (along with other columns also in Pivot table)
Below is the sample table which shows the issue.
When I place Hierarchy column (Region) in Pivot table then "Show Subtotal" option will not comes. But for normal columns I am able to get Subtotal values.
Region (Hierarchy column) Product Type Amount(Measure) Europe A 100 B 200 Sub Total 300 Asia A 150 B 250 Sub Total 400 Grand Total 70
Hope this clarifies my issue. Let me know if I get any help.
1 person found this helpful
Using New calculated Item we can do...
Region (Hierarchy column), Product Type - In rows section
-Click on Product type -> Select New Calculated Item
Display Label: Sub Total
Click on Move all and select all Product Type values
Click on "ok"
Display the results as you expect...
Mark as correct it helps u...
Thanks for the reply.
This is good solution. But the problem with this solution is when I move to detailed levels of Hierarchy, Subtotal values are displaying Zero value for all levels.
The hierachical column has no "show subtotal" option, because, in my opinion, it has subtotalling in itself. In other words, subtotal "is" the member corresponding to your total regions member. I think it's another way to display / navigate data, subtotal here is not so appropriate.
Hope this helps,