topic Additional AVG in row in App Development https://community.qlik.com/t5/App-Development/Additional-AVG-in-row/m-p/1676753#M63726 <P>Hello, I&nbsp; use a pivot table to calculate rolling 12 month overtime for our employees.</P><P>I also have total row sum and total column sum.</P><P>Now I need to also have a total average for every row.</P><P>How can i do that?</P><P>Other problem is, that the condition for coloration of the total fields is different than the normal fields...</P><P>Has anybody a solution?</P><P>Here is a little screenshot of what i am doing.</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="overtime.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/28592i98A732888CA9FAD3/image-size/large?v=v2&amp;px=999" role="button" title="overtime.png" alt="overtime.png" /></span></P><P>Best regards</P><P>Heiko</P><P>&nbsp;</P> Fri, 02 Apr 2021 08:19:36 GMT heiko_schmidt 2021-04-02T08:19:36Z Additional AVG in row https://community.qlik.com/t5/App-Development/Additional-AVG-in-row/m-p/1676753#M63726 <P>Hello, I&nbsp; use a pivot table to calculate rolling 12 month overtime for our employees.</P><P>I also have total row sum and total column sum.</P><P>Now I need to also have a total average for every row.</P><P>How can i do that?</P><P>Other problem is, that the condition for coloration of the total fields is different than the normal fields...</P><P>Has anybody a solution?</P><P>Here is a little screenshot of what i am doing.</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="overtime.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/28592i98A732888CA9FAD3/image-size/large?v=v2&amp;px=999" role="button" title="overtime.png" alt="overtime.png" /></span></P><P>Best regards</P><P>Heiko</P><P>&nbsp;</P> Fri, 02 Apr 2021 08:19:36 GMT https://community.qlik.com/t5/App-Development/Additional-AVG-in-row/m-p/1676753#M63726 heiko_schmidt 2021-04-02T08:19:36Z