Percentage based on dimension

[User12321]

Hi,

I have a pivot table with dimensions Category and Item. I want to create a percentage column defined as the item amount divided by the item category amount. 

Any suggestion on how to create the percentage column please. Thank you.

[rubenmarin · Accepted solution]

Hi, you can use the TOTAL qualifier to tell the expression to ignore dimensions, and between <> tell wich dimension it has to use, so this can be:

Sum(Amount)/Sum(TOTAL <CategoryFieldName> Amount)