LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kay Kay is offline
external usenet poster
 
Posts: 129
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table data source FerrariWA Excel Discussion (Misc queries) 1 July 6th 09 05:48 PM
Pivot table data source gordonrss Excel Discussion (Misc queries) 0 February 11th 09 03:08 PM
Pivot table data source FredH Excel Worksheet Functions 1 November 16th 07 04:54 AM
Pivot Table Source Data Jani Excel Discussion (Misc queries) 2 March 6th 07 07:42 PM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"