Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
spividori
Specialist
Specialist

Average

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:Captura.PNG

Captura1.PNG

1 Solution

Accepted Solutions
sunny_talwar

May be this

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

View solution in original post

3 Replies
sunny_talwar

May be this

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

Anonymous
Not applicable

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

spividori
Specialist
Specialist
Author

Hi.

Thanks for answering. It works perfect.

Regards.