excel from pivot table back to original data

[jimjohn]

can somenoe plz help me with this:
i have a pivottable in excel with many different filters, but now i want to be able to see my original data set. for example, if i double click one of the cells in the pivot table, it will show me a part of the original data set given various filters e.g. but how do i get to see my whole original data set? thanks!

 

[RoryA]

Remove all row, column and page fields, just leaving a data field. Then double click the data field and you should get all the detail data shown.

 

[jimjohn]

sorry this is a pretty dumb question but hwo do i remove alkl the other fields? what do i click on and then how do i get my original data? ive never used pivottables before and just want to see the original data. thanks so much!

 

[RoryA]

You should be able to just click and drag the field headers off the pivot table to remove them.