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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Luisanabria
Creator
Creator

Add % in a Pivot Table

Hi everybody

One question, hope can help me, please.

I have this table:

fernandoflogtz_0-1695834517864.png

Is possible to add a column % for every month? Something like this:

fernandoflogtz_2-1695834734052.png

and at the end of my table add a Total Column as my Excel example?

Can someone help me, l try but not succed
Thanks

 

Labels (4)
1 Reply
VatsalyaSolanki
Contributor III
Contributor III

Hii @Luisanabria ,

For adding the % column for every month, you need to add a measure in your pivot table where you would calculate the percentage just as you would do for Sum(Amount).  For adding a "Totals" column just turn on the Toggle Button titled  'Show Totals'  under your date dimension.

Accept as answer, if the solution works for you.