Average

[spividori]

Hi.

I need to calculate the percentage in a pivoting table with 2 dimensions, Imputation and Year. I use Sum (Quantity) / Sum (Total Amount) but it does not work. I have tried several without success.

Desired result:

[sunny_talwar · Accepted solution]

May be this

Sum(Quantity)/Sum(TOTAL <Ano> Quantity)

[Anonymous]

Sum(Quantity)/Sum(TOTAL <Ano> Quantity)

[spividori]

Hi.

Thanks for answering. It works perfect.

Regards.