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?
Dimensions: field1, field2, field3
Formulas: sum1, sum2
View in Pivot table: field1, field2, field3, sum1, sum2
New view: field1, field2, sum1, field3, sum2
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.