Calculate Percentages dynamically over columns on a Pivot Table

[Stevan_Klaas]

Dear Community,

I am trying to have a pivot table to calculate a measure divided by the total of this measure accross a column field.

And I want the percentage to be calculated dynamically on the first column, whatever field is placed there by the user.

In the formula sum (total <Market> Sales), the modifier should be dynamic based on the first column field.

Thanks,

Stevan

[jbhappysocks · Accepted solution]

Hi!

If I understand what you want to achieve correctly  <"$(=GetObjectDimension(1))">  should do the trick. 

[Stevan_Klaas]

Just perfect and easy !

Thanks a lot !!

Stevan