Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
I have a pivot table that works well as long as I only want to look at some
data in a single value form. For example: I have test results for all 8th graders in an entire school district condensed into 1 table. I have the particular test filtered out and only the students who took the test in English (score code E) show in the pivot table. I use that to get campus results for that version of the test. I also do the same for the Spanish version (score code S). What I need is for students who took the test in English and Spanish (score codes E and S) together by campus. How can I set the pivot chart to add them together? I select all fro mthe score code section and the pivot chart shows all of the E takers and how they did by campus and then shows all of S and how they did by campus. I need E and S added together and how they all did by campus. How do I do that? -- Thanks As Always Rip |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
Temporarily move the Test field into the row area
From the dropdown list of tests, select Spanish and English Move the Test field back to the Page area. Ripper wrote: I have a pivot table that works well as long as I only want to look at some data in a single value form. For example: I have test results for all 8th graders in an entire school district condensed into 1 table. I have the particular test filtered out and only the students who took the test in English (score code E) show in the pivot table. I use that to get campus results for that version of the test. I also do the same for the Spanish version (score code S). What I need is for students who took the test in English and Spanish (score codes E and S) together by campus. How can I set the pivot chart to add them together? I select all fro mthe score code section and the pivot chart shows all of the E takers and how they did by campus and then shows all of S and how they did by campus. I need E and S added together and how they all did by campus. How do I do that? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions |