Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)