Pivot table question

[Ian Elliott]

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.

 

[ShaneDevenshire]

Hi,

It's not at all clear how your data is set up but suppose you have
Born Died Years
where the Years is =Died-Born

1. Select the data and choose Data, PivotTable & PivotChart Report,
2. Click Next twice. and then Layout
3. Drag the Years field to the Row area and to the Data area
4. Drag the Birth field to the Column area
5. Double-click the Years field in the Data area and change the calculation
to Count.
6. Click OK, Finish.


If this helps, please click the Yes button.