Pivot table and percentage

[dmonder]

I have an excel spreadsheet with the following information:

SCHOOL, PERSON, SUBJ, COURSE_TYPE, COURSE, SECTION, TERM,
OUTSIDE_RANGE
AA, John Doe, Math, 1U, 101, 01, 200508, 0
AA, John Doe, Math, 1U, 102, 01, 200508, 1
AA, John Doe, Math, 1G, 601, 70, 200508, 0
AA, John Doe, Math, 1U, 101, 01, 200601, 0
AA, John Doe, Math, 1U, 101, 02, 200601, 1
AA, John Doe, Math, 1U, 101, 03, 200601, 1
AA, John Doe, Math, 1U, 101, 01, 200608, 0
AA, John Doe, Math, 1U, 102, 01, 200608, 1
AA, John Doe, Math, 1U, 103, 01, 200608, 0

I want to be able to have in a pivot table the following:

Page
TERM

Rows
SCHOOL by PERSON by SUBJ by COURSE_TYPE by COURSE

Data
OUTSIDE_RANGE (both a total and a percentage at current level)


I would like to see the data at multiple levels.

TERM=200508

AA
John Doe
Math
1U 1 50%
1G 0 0%
Phys
1G 1 100%

-------------------------------- OR --------------------------------

TERM=200508

AA
John Doe
Math 1 33%
Phys 1 100%

-------------------------------- OR --------------------------------

TERM=200508

AA
John Doe 2 50%

-------------------------------- OR --------------------------------

TERM=All

AA
John Doe
Math
1U 4 50%
1G 0 0%
Phys
1G 1 100%

-------------------------------- OR --------------------------------

TERM=All

AA
John Doe
Math 4 44%
Phys 1 100%

-------------------------------- OR --------------------------------

TERM=All

AA
John Doe 5 50%

------------------------------------------------------------------------

Is this possible? I can get the totals for the OUTSIDE_RANGE field
but I cannot get the percentages to work. Any help would be GREATLY
appreciated.

David