https://community.qlik.com/t5/App-Development/Pivot-Table-and-general-Average/m-p/1635767#M47366 <P>hi,</P><P>Sample Data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_0.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21619iE219ADA960C2919E/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></span></P><P>&nbsp;</P><P>Result :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_1.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21620iEE55854F3908B0E5/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_1.png" alt="clipboard_image_1.png" /></span></P><P>Set for Dim in Row:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_2.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21622iCE54D33E330A4E72/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_2.png" alt="clipboard_image_2.png" /></span></P><P>Set Column:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_3.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21623i8796127E19CD2134/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_3.png" alt="clipboard_image_3.png" /></span></P><P>set measure:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_4.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21624iB66445A3C81724C7/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_4.png" alt="clipboard_image_4.png" /></span></P><P>Try this, you will have result</P><P>&nbsp;</P><P>K. Srinivasan</P> Wed, 16 Oct 2019 06:18:10 GMT Ksrinivasan 2019-10-16T06:18:10Z https://community.qlik.com/t5/App-Development/Pivot-Table-and-general-Average/m-p/1635593#M47350 <P>Hi Experts</P><P>Someone can support me as I can solve the following question.</P><P>I have a pivot table with the transactions per day and even the average side, the drawback is that this average is giving me per day and what I need is that in each day I show the total average.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="captura1.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21566iE2895F50D7D7CE08/image-size/large?v=v2&amp;px=999" role="button" title="captura1.PNG" alt="captura1.PNG" /></span></P><P>currently this is the formula.</P> Sat, 16 Nov 2024 19:53:39 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-and-general-Average/m-p/1635593#M47350 tenmaster10 2024-11-16T19:53:39Z https://community.qlik.com/t5/App-Development/Pivot-Table-and-general-Average/m-p/1635767#M47366 <P>hi,</P><P>Sample Data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_0.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21619iE219ADA960C2919E/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></span></P><P>&nbsp;</P><P>Result :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_1.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21620iEE55854F3908B0E5/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_1.png" alt="clipboard_image_1.png" /></span></P><P>Set for Dim in Row:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_2.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21622iCE54D33E330A4E72/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_2.png" alt="clipboard_image_2.png" /></span></P><P>Set Column:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_3.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21623i8796127E19CD2134/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_3.png" alt="clipboard_image_3.png" /></span></P><P>set measure:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_4.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21624iB66445A3C81724C7/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_4.png" alt="clipboard_image_4.png" /></span></P><P>Try this, you will have result</P><P>&nbsp;</P><P>K. Srinivasan</P> Wed, 16 Oct 2019 06:18:10 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-and-general-Average/m-p/1635767#M47366 Ksrinivasan 2019-10-16T06:18:10Z https://community.qlik.com/t5/App-Development/Pivot-Table-and-general-Average/m-p/1635801#M47369 <P>Try Using the AGGR Function</P> Wed, 16 Oct 2019 07:16:24 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-and-general-Average/m-p/1635801#M47369 anushree1 2019-10-16T07:16:24Z