Is there a way to create two pivot tables from the same set of results that will refresh when the query is run? Thanks!
I’v never done that before. But conceivably you should be able to send the results to an Excel template and define two pivots off of the same set of data. See this video on how to do one set. www.toadworld.com/…/1142