get source data from pivot table

K

kay

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Challenge when some Data is Identical 0
Use index and match function to get data from pivot table 1
Get data from pivot table (using VBA / index and match function) 0
Preparing Data for Pivot Table 1
How can I change the source data reference to another pivot table? 2
pivot table (or list) calculations 0
Pivot Table help 0
Pivot Table Summarizing Quirk - Please Help 1

Top