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: 
navaskhan
Contributor III
Contributor III

Pivot and Percentage

    Ho to achieve this in Pivot Table with Aggr Function ?

CustomerJanJan %
A

50

50%
B1010%
C2020 %
D2020 %
100100 %
1 Solution

Accepted Solutions
sunny_talwar

Try this:

Sum(Measure)/Sum(TOTAL <Customer> Measure)

or

Sum(Measure)/Sum(TOTAL <Month> Measure)

View solution in original post

4 Replies
vikasmahajan

=column(2)/100   and  tick on Show in %

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
sunny_talwar

May be this:

Sum(Measure)/Sum(TOTAL Measure)

navaskhan
Contributor III
Contributor III
Author

This is not working in case of Multiple Months. Because Total will take the Jan & Feb Total.

sunny_talwar

Try this:

Sum(Measure)/Sum(TOTAL <Customer> Measure)

or

Sum(Measure)/Sum(TOTAL <Month> Measure)