Pivot Table Sub-Totals

[rishimessi19]

- Above chart is a pivot table

- 2 dimensions (one vertical and other horizontal)

- 9 expressions (marked in GREEN)

Question:

1. I do not want subtotals for 2 expressions marked in RED at the bottom. Is it possible?

2.Also, can we have Subtotals - "Top" for one dimension and "bottom" for the other (Option available in presentation tab) ?

[sunny_talwar · Accepted solution]

You can use Dimensionality() and SecondDimensionality() to fix this. For more information on these two functions check the blogs by Robert_Mika‌

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()