Using non standard actions on an Excel 97 pivot table

H

Hackensack

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?
 
S

steven1001

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..
 
H

Hackensack

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.
 
Top