https://community.qlik.com/t5/QlikView/How-to-Make-calculation-in-Pivot-table/m-p/2068402#M1223550 <P>Last date of the month should be subtracted from max date of data.</P> <P>Note- Only 7 day data will show in pivot table .</P> <P>please see i have attached&nbsp; demo of final result excel screnshot .</P> Sat, 06 May 2023 19:49:44 GMT arpitjoshi 2023-05-06T19:49:44Z https://community.qlik.com/t5/QlikView/How-to-Make-calculation-in-Pivot-table/m-p/2068402#M1223550 <P>Last date of the month should be subtracted from max date of data.</P> <P>Note- Only 7 day data will show in pivot table .</P> <P>please see i have attached&nbsp; demo of final result excel screnshot .</P> Sat, 06 May 2023 19:49:44 GMT https://community.qlik.com/t5/QlikView/How-to-Make-calculation-in-Pivot-table/m-p/2068402#M1223550 arpitjoshi 2023-05-06T19:49:44Z