topic Calculating %age for grand total column in QlikView https://community.qlik.com/t5/QlikView/Calculating-age-for-grand-total-column/m-p/406763#M568356 <HTML><HEAD></HEAD><BODY><P>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?</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>=(<SPAN style="color: #0000ff; font-size: 8pt;">Column</SPAN><SPAN style="font-size: 8pt;">(8)/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Column</SPAN><SPAN style="font-size: 8pt;">(9))-1 </SPAN></P><P></P></BODY></HTML> Tue, 06 Nov 2012 12:00:03 GMT 2012-11-06T12:00:03Z Calculating %age for grand total column https://community.qlik.com/t5/QlikView/Calculating-age-for-grand-total-column/m-p/406763#M568356 <HTML><HEAD></HEAD><BODY><P>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?</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>=(<SPAN style="color: #0000ff; font-size: 8pt;">Column</SPAN><SPAN style="font-size: 8pt;">(8)/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Column</SPAN><SPAN style="font-size: 8pt;">(9))-1 </SPAN></P><P></P></BODY></HTML> Tue, 06 Nov 2012 12:00:03 GMT https://community.qlik.com/t5/QlikView/Calculating-age-for-grand-total-column/m-p/406763#M568356 2012-11-06T12:00:03Z