topic Pivot Table Expression Row Total Calculations by Header Group in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Expression-Row-Total-Calculations-by-Header-Group/m-p/1447344#M433615 <HTML><HEAD></HEAD><BODY><P>I have a KPI report in excel that I am attempting to recreate in Qlik. I have the month 1 and month 2 columns with there respective expressions. But i need an total of the 2 months as well.</P><P></P><P><IMG alt="2017-12-07 15_58_17-Microsoft Excel - 2017-10_FC Accuracy.xlsx.png" class="jive-image image-1" src="/legacyfs/online/186145_2017-12-07 15_58_17-Microsoft Excel - 2017-10_FC Accuracy.xlsx.png" style="height: 40px; width: 620px;" /></P><P></P><P>I've gotten this far in Qlik but unfortunately I'm a little stuck. I basically need a 3rd header group the combines the 2 months.</P><P></P><P><IMG alt="Qlik Report.png" class="jive-image image-2" src="/legacyfs/online/186173_Qlik Report.png" style="height: 57px; width: 620px;" /></P><P></P><P>Thank you ahead of time for any assistance.</P></BODY></HTML> Thu, 07 Dec 2017 21:07:28 GMT Anonymous 2017-12-07T21:07:28Z Pivot Table Expression Row Total Calculations by Header Group https://community.qlik.com/t5/QlikView/Pivot-Table-Expression-Row-Total-Calculations-by-Header-Group/m-p/1447344#M433615 <HTML><HEAD></HEAD><BODY><P>I have a KPI report in excel that I am attempting to recreate in Qlik. I have the month 1 and month 2 columns with there respective expressions. But i need an total of the 2 months as well.</P><P></P><P><IMG alt="2017-12-07 15_58_17-Microsoft Excel - 2017-10_FC Accuracy.xlsx.png" class="jive-image image-1" src="/legacyfs/online/186145_2017-12-07 15_58_17-Microsoft Excel - 2017-10_FC Accuracy.xlsx.png" style="height: 40px; width: 620px;" /></P><P></P><P>I've gotten this far in Qlik but unfortunately I'm a little stuck. I basically need a 3rd header group the combines the 2 months.</P><P></P><P><IMG alt="Qlik Report.png" class="jive-image image-2" src="/legacyfs/online/186173_Qlik Report.png" style="height: 57px; width: 620px;" /></P><P></P><P>Thank you ahead of time for any assistance.</P></BODY></HTML> Thu, 07 Dec 2017 21:07:28 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Expression-Row-Total-Calculations-by-Header-Group/m-p/1447344#M433615 Anonymous 2017-12-07T21:07:28Z