I have a data table containing 52 weeks data on 20 people e.g. number of
holidays taken in a particular week, Income in a particular week.
I'm using pivot table to summarise the data and need to use a non standard
command to select the last income figure (say week 52) for each of the
persons rather than for example Sum of Income.
Any ideas?

Assuming you dont want to do this every day...
Sort the data by person and amount .. in a helper column use some
command like..
=if([name]<[name in cell above],"use","ignore")
Then add that column to the PAGE area and fiter out the "ignore"
values.
There must be a better way :-)
regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=528896

Thanks Steven. There is a better way! I was advised today to cut my losses
and use a second pivot table driven from the same data. On this pivot, I
have included 'DATE' on the page and this allows me to select the date on the
line that I wish to draw the data from. It works well.

"steven1001" wrote:


Assuming you dont want to do this every day...
Sort the data by person and amount .. in a helper column use some
command like..
=if([name]<[name in cell above],"use","ignore")
Then add that column to the PAGE area and fiter out the "ignore"
values.
There must be a better way :-)
regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=528896