Hi All,
I am trying to implement a pivot table where I can hide the dimension for Expression 3 only and not sure if it is possible.
What I want to create looks like this:
| Expression 1 | Expression 1 | Expression 1 | Expression 2 | Expression 2 | Expression 2 | Expression 3 |
| Vendor | Apr | May | Total | Apr | May | Total | Total |
|---|
| Vendor 1 | | | | | | | |
| Vendor 2 | | | | | | | |
| Vendor 3 | | | | | | | |
| Vendor 4 | | | | | | | |
| Total | | | | | | | |
My Dimensions Are:
Vendor
Month
My Expressions Are:
Expression 1
Expression 2
Expression 3
In order to get the Total columns I simply checked the following boxes:
Presentation -> Vendor -> Show Partial Sums
Presentation -> Month -> Show Partial Sums
The only thing left to do is to show Expression 3, however when I add expression 3 it will show me the columns Apr, May and YTD. How can I make expression 3 show only the Total?
Thanks,
Riley
