Forum Discussion
how to get only very last day figure's total, avg, etc in pivot table of any selected period
How to get total of only very lat day of selected period in Pivot table. By default pivot is giving total of full data.
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)
Hi Ravindra,
Right click on that column, Value Field Settings and insted of Sum select Max, like this
in that case it's showing wrong figure for qtr 3 which 15.
should be 9 ( Sept Month end Figure)
Yes, you are right. If your table is added to data model you may add measure
MaxPersons=LOOKUPVALUE(Table1[Persons],Table1[Month],MAX(Table1[Month]))
and calculate on it
