Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables and percentages
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Percentages | Excel Discussion (Misc queries) | |||
Calculating percentages in pivot tables on subtotals | Excel Worksheet Functions | |||
Percentages in Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Table percentages | Excel Discussion (Misc queries) | |||
Pivot Tables & Percentages | Excel Discussion (Misc queries) |