Thanks for any help.
I want to make a pivot table on 2 fields. The y-axis has the "birth year"
(ie 1990), and the x-axis has the "years of life" (ie 4). The inner data is
the number of people/records/etc alive born at that year, that many years in.
I would like the pivot table to sum the number of records (this pivot table
is based on a query which has the birth years and years of life) for each
year that they are alive.
Something like this:
x-axis: 0,1,2,3,4,5
y-axis:1988,1990,1991
data(for example):
8,7,6,6,5,5
9,9,9,9,9,6
5,3,3,2,2,1
The data would have a birth year and a death year for each record.
I don't know how to do this with pivot tables using sum or count.
Any help much appreciated.