- Above chart is a pivot table
- 2 dimensions (one vertical and other horizontal)
- 9 expressions (marked in GREEN)
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) ?
You can use Dimensionality() and SecondDimensionality() to fix this. For more information on these two functions check the blogs by robert_mika