Pivot Table Question - KIND of UrgentTh

[becca616]

Hi,

I am appreciative of any comments or suggestions. I am trying to create
a table to summarize the number of degrees granted by type (PhD,
Master, Undergrad, and PB)
and by term of graduation. I have totals for each year 1983-2006, but
now I want to break it down by fiscal year (spring, summer, and fall).
I made a pivot table with terms across the top and year down the side,
but I can't figure out how to GROUP the spring, summer, and fall values
together, to create a summary of degrees granted by type by fiscal
year.

Anyone know how to group rows of data like this, and get subtotals?


Thanks, )

 

[Dave Peterson]

I would use a helper column in the raw data that would look at the date and
determine which semester applies.

Do you keep track of a range of dates--or just the date that graduation takes
place?

What dates define spring, summer, fall (no winter??).