Pivot Table Question - KIND of UrgentTh

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, )

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??).

"becca616@gmail.com" wrote:
>
> 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