topic Calculate Percentages dynamically over columns on a Pivot Table in App Development

Calculate Percentages dynamically over columns on a Pivot Table

Stevan_Klaas — Wed, 29 Sep 2021 16:21:29 GMT

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 — Thu, 30 Sep 2021 09:20:44 GMT

Hi!

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

Stevan_Klaas — Thu, 30 Sep 2021 09:43:24 GMT

Just perfect and easy !

Thanks a lot !!

Stevan