![]() |
get source data from pivot table
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 |
All times are GMT +1. The time now is 06:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com