software

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

quot; wrote:
gt;
gt; Hi,
gt;
gt; I am appreciative of any comments or suggestions. I am trying to create
gt; a table to summarize the number of degrees granted by type (PhD,
gt; Master, Undergrad, and PB)
gt; and by term of graduation. I have totals for each year 1983-2006, but
gt; now I want to break it down by fiscal year (spring, summer, and fall).
gt; I made a pivot table with terms across the top and year down the side,
gt; but I can't figure out how to GROUP the spring, summer, and fall values
gt; together, to create a summary of degrees granted by type by fiscal
gt; year.
gt;
gt; Anyone know how to group rows of data like this, and get subtotals?
gt;
gt; Thanks, )

--

Dave Peterson