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.
May be this
Sum(Quantity)/Sum(TOTAL <Ano> Quantity)
Thanks for answering. It works perfect.
Retrieving data ...