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: 
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