Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have created pivot table from around 46000 rows and 10 columns
Student Group Semester Total Studnet Count StudentID USA Spring08 4237 0 Summer08 2432 2 Fall08 2624 2 Spring09 4156 12 Summer09 3398 11 Fall09 1143 2 Spring10 259 1 USA Total 18249 30 In this example 11 students fall in €˜Summer09 category and I want StudentID for this 11 students. And Total is around 18250. So when I double click on 11 to view the details, it gives me all 18250 rows But what I want is it just shows StudentID/data for those 11 students only. Is this possible? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table data source | Excel Discussion (Misc queries) | |||
Pivot table data source | Excel Discussion (Misc queries) | |||
Pivot table data source | Excel Worksheet Functions | |||
Pivot Table Source Data | Excel Discussion (Misc queries) | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |