Display all records SQL query

[Dharris144]

I have spreadsheet that is populated by an SQL query from our DB. The query is populating a pivot table and I would like to know how to see the data. I ma looking to basically do a data dump into a table if possible.

 

[Fazza]

hi, Does a double click in the grand total (of the pivot table) do what you want?

 

[Dharris144]

The workbook has several pivot tables with several filters and I dont want to miss any combinations