Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Alam
Contributor II
Contributor II

Percentage of total column in Pivot Table

I have a pivot table with ID and account as rows, Month (Oct, Nov, Dec) as columns and a total field.

I wish to show the percentage of column total for each month and obviously that'd change dynamically as each item is being filtered on.

Alam_0-1675763487083.png

 

Labels (2)
2 Replies
vinieme12
Champion III
Champion III

count(Measure) / Count(TOTAL <ColumnDimension> Measure)

Or

count(Measure) / Count(TOTAL <RowDimension> Measure)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Alam
Contributor II
Contributor II
Author

Thank you @vinieme12 it worked perfectly. However, is there a way to keep the values fixed? Currently, the % values change based on whatever we filter. I'm wanting that even when I filter for a specific account type, it shows me as a percentage of the entire month, rather than as a percentage of the selection.