topic Re: calculate last 12 months average in pivot table in App Development https://community.qlik.com/t5/App-Development/calculate-last-12-months-average-in-pivot-table/m-p/1748895#M57574 <P>i can share QVF file file size almost 80 mb&nbsp; i ll try to reduce tomorrow and i will send&nbsp;&nbsp;</P> Thu, 01 Oct 2020 15:10:03 GMT Omkarsv2891 2020-10-01T15:10:03Z calculate last 12 months average in pivot table https://community.qlik.com/t5/App-Development/calculate-last-12-months-average-in-pivot-table/m-p/1748003#M57506 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Omkarsv2891_0-1601370086340.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/41375iBF137C0AA06C6AE9/image-size/medium?v=v2&amp;px=400" role="button" title="Omkarsv2891_0-1601370086340.png" alt="Omkarsv2891_0-1601370086340.png" /></span></P><P>final out put require last two column in qlik sense pivot table</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Omkarsv2891_0-1601370447827.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/41376i645CE1A17348A978/image-size/medium?v=v2&amp;px=400" role="button" title="Omkarsv2891_0-1601370447827.png" alt="Omkarsv2891_0-1601370447827.png" /></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 18:02:44 GMT https://community.qlik.com/t5/App-Development/calculate-last-12-months-average-in-pivot-table/m-p/1748003#M57506 Omkarsv2891 2024-11-16T18:02:44Z Re: calculate last 12 months average in pivot table https://community.qlik.com/t5/App-Development/calculate-last-12-months-average-in-pivot-table/m-p/1748852#M57571 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/122105">@Omkarsv2891</a>&nbsp;would you be able to provide the sample data in an Excel file or qvf where the data is already loaded?</P> Thu, 01 Oct 2020 13:40:57 GMT https://community.qlik.com/t5/App-Development/calculate-last-12-months-average-in-pivot-table/m-p/1748852#M57571 sunny_talwar 2020-10-01T13:40:57Z Re: calculate last 12 months average in pivot table https://community.qlik.com/t5/App-Development/calculate-last-12-months-average-in-pivot-table/m-p/1748895#M57574 <P>i can share QVF file file size almost 80 mb&nbsp; i ll try to reduce tomorrow and i will send&nbsp;&nbsp;</P> Thu, 01 Oct 2020 15:10:03 GMT https://community.qlik.com/t5/App-Development/calculate-last-12-months-average-in-pivot-table/m-p/1748895#M57574 Omkarsv2891 2020-10-01T15:10:03Z