Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
wonkymeister
Creator III
Creator III

Pivot Table with Column Percentages

Hi,

I have a pivot table, with YEAR across the top (3 years so 3 columns), with the user being able to select from a list of available dimensions down the side.

I need the % to calculate for each individual column (year), as opposed to a percentage of the total.

Any ideas?outcomes_pivot.PNG

10 Replies
jmvilaplanap
Specialist
Specialist

I think no, because there is in a pivot table, then automatically the results are "filtered" to fit each cell, is because you need to use "TOTAL"

It will be possible to use it in a text object using filters, but I think is not that are you looking for.