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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating %age for grand total column

Hi - It seems that I have got all working except the grand total % calcuation. For ex, I have % calculation based on the other columns and it works for all rows except the last grand total. This is because the other columns that I used for %age calucation was showing the sum as Total Mode as "SUM" which is adding all rows instead of Expression Total. As a result, my % calculation works for all rows except total. Is there anyway we can get % age calculation for grand total as well?

 

=(Column(8)/Column(9))-1

0 Replies