topic Calculations in group footer in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Calculations-in-group-footer/m-p/1410109#M19680 <HTML><HEAD></HEAD><BODY><P>For a pixelperfect report, we have simple sum fields in the group footer but</P><P>we want to see the pct of total for each column.&nbsp; For example</P><P></P><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid rgb(0, 0, 0); width: 196px; height: 16px;"><TBODY><TR><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">80</TD></TR><TR><TD>62%</TD><TD>25%</TD><TD>12%</TD><TD>100%</TD></TR></TBODY></TABLE><P></P><P>I'm using a formula but from the lengthy generation, I get the impression it's calculating for every detail row.</P><P>Can we reference a footer cell somehow?</P></BODY></HTML> Wed, 13 Sep 2017 16:38:40 GMT markp201 2017-09-13T16:38:40Z Calculations in group footer https://community.qlik.com/t5/Qlik-NPrinting/Calculations-in-group-footer/m-p/1410109#M19680 <HTML><HEAD></HEAD><BODY><P>For a pixelperfect report, we have simple sum fields in the group footer but</P><P>we want to see the pct of total for each column.&nbsp; For example</P><P></P><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid rgb(0, 0, 0); width: 196px; height: 16px;"><TBODY><TR><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">80</TD></TR><TR><TD>62%</TD><TD>25%</TD><TD>12%</TD><TD>100%</TD></TR></TBODY></TABLE><P></P><P>I'm using a formula but from the lengthy generation, I get the impression it's calculating for every detail row.</P><P>Can we reference a footer cell somehow?</P></BODY></HTML> Wed, 13 Sep 2017 16:38:40 GMT https://community.qlik.com/t5/Qlik-NPrinting/Calculations-in-group-footer/m-p/1410109#M19680 markp201 2017-09-13T16:38:40Z