how to get only very last day figure's total, avg, etc in pivot table of any selected period

Question

How to get total of only very lat day of selected period in Pivot table.By default pivot is giving total of full data.&nbsp;&nbsp;

wyn hopkins · Answer

Could you provide some more information and ideally a demo file and screenshots please

ravindra chaugule · Answer

I Need actual no's of sales person in pivot at the end of each quarter instead of total all three months (Column- highlighted in Yellow)

ravindra chaugule · Answer

sergeibaklan · Answer

Hi Ravindra,
&nbsp;
Right click on that column, Value Field Settings and insted of Sum select Max, like this

&nbsp;

ravindra chaugule · Answer

in that case it's showing wrong figure for qtr 3 which 15.&nbsp;should be 9 ( Sept Month end Figure)

Forum Discussion