Solved: Pivot and Percentage - Qlik Community

navaskhan · ‎2016-08-17

Ho to achieve this in Pivot Table with Aggr Function ?

Customer	Jan	Jan %
A	50	50%
B	10	10%
C	20	20 %
D	20	20 %
	100	100 %

sunny_talwar · ‎2016-08-17

Try this:

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

or

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

View solution in original post

vikasmahajan · ‎2016-08-17

=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 · ‎2016-08-17

May be this:

Sum(Measure)/Sum(TOTAL Measure)

navaskhan · ‎2016-08-17

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

sunny_talwar · ‎2016-08-17

Try this:

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

or

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

Pivot and Percentage

Related Topics