Set analysis in Pivot table sub total / Customized total
Hi,
I have a pivot table with “month year” as dimension and 5 expressions in the below format. We show rolling 12 months data based on user selections.
month 1
month 2
…
month 12
expression 1
x
x
x
x
…
x
x
x
x
expression 5
x
x
x
x
I want to add Fiscal year total as the last column to this. Ie, Fiscal year totals should be populated in the last column irrespective of the months being displayed.
month 1
month 2
…
month 12
FY Totals
expression 1
x
x
x
x
x
…
x
x
x
x
x
expression 5
x
x
x
x
x
Also, each total row has the expression mentioned in that row.
One way could be to add the value of "FY Totals" to your "month year" field (maybe you create an extra one only for this purpose) and then you could query these value within the expressions, like:
Another way would be to add simply a further dimension as a calculated dimension like: = 'FY Totals' and enabling partial sums for this dimension and within the expressions you query the dimensionality, like:
