I have just started getting my hands dirty with Toad Pivot grids and I must say a very handy feature. Kudos!
I would like to get your opinion on my findings/questions
Once the TPG file is dumped to XLSX, I tried setting up the data filters and noticed that the filters are absolute i.e., unlike a regular excel filter where all the other columns get affected based on selection of one column. The generated excel somehow shows blank for all columns apart from the one which I have selected to filter on.
Like excel, where the user can double click on any row in the Pivot Table and those set of row(s) would open up in a worksheet, is there a way to enable this for the Toad Pivot Grid output(s)
Thank you for your guidance.