Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
May be this
Sum(Quantity)/Sum(TOTAL <Ano> Quantity)
Sum(Quantity)/Sum(TOTAL <Ano> Quantity)
Hi.
Thanks for answering. It works perfect.
Regards.