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?