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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.