Need help in writing the expression for total in pivot table

[ferha_jafri]

Hello everyone,

I need help in writing the expression for total in pivot table.In my case i have two dimension one is state and one is product and they want to view the total for both the dimensions.Now the issue is that they want product dimension at the top of the table so when i am writing an expression for the total it is different for both the dimension so i want to know how i can do this.

[jonathandienst · Accepted solution]

Hi

You can write an expression that evaluates differently for the total rows by using Dimensionality()

If(Dimensionality() = 0, ... expression for grand total of all states/products ... ,

    If(Dimensionality() = 1,  ... expression for total for all products in each state  ... ,

        If(Dimensionality() = 2, ... expression for total per product ... ,

          ... expression for detail lines

        )

    )

)

HTH

Jonathan