Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a Pivot table there are dimensions and formulas. In the properties of a pivot table dimensions can be order, formulas are following. How can I change the order of dimensions and formulas?
For example:
Dimensions: field1, field2, field3
Formulas: sum1, sum2
View in Pivot table: field1, field2, field3, sum1, sum2
New view: field1, field2, sum1, field3, sum2
Regards Stefan
I don't think it's possible to change the order like that.
If you want to show soemthing like subtotals or even different sums on different levels of aggregation, you can use partial sums (enable on presentation tab), and maybe dimensionality() function in a conditional to decide which expression to use.