Dynamic Total in Pivot Table

[Tim_G]

Hello there,

I woul like to calculate the total of a row in a pivot table. Usually this works well with "Sum(total <TYPE> SALES)"

In my example I use it to calculate the market share such as follows:

Sum([SALES_EUR])
/Sum(total <YEAR,COUNTRY> [SALES_EUR])

However this total by TYPE is fixed on the dimensions YEAR,COUNTRY here. If I want wo change dimensions such that e.g. PRODUCTGROUP is a row and COUNTRY becomes a column than I get incorrect totals.

If I move PRODUCTGROUP to the left by drag and drop, then I would like to become the formualr "Sum(total <PRODUCTGROUP> [SALES_EUR])" dynamically? Maybe dimensionality() could help but I could not figure it out yet.

Thanks in advance, Tim

[Tim_G]

Oof, I missed that. So sorry! 😥