ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   get source data from pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/247403-get-source-data-pivot-table.html)

Kay

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