Hi all,

Not sure if this is possible but is there a way to see all the data behind a pivot tables results all at once? I know you can double click into each line item and it will open a new worksheet with that data but is there a way to do this all at once for all the data that is present on the pivot table rather then going line by line. I am trying to aggregate all the data into one sheet. TIA!