#15922: Add option to modify Pivot Table request in Query Analyzer

gladiusora reported 2023-03-17T17:27:13Z · last modified 2023-03-17T17:27:13Z

Dev
QA

Priority	Low
Complexity	Unknown

Component	Q Analyzer - Grid Results
Version	22.2

- Customer would like the option to modify the pivot table to provide a total result set for a table compared to getting results only for what is in the grid. (See below)
If I have a column that I want to total, I would go to the pivot to show me a total of the column. However, this would only give me a total of what is currently in the grid.
When I am in the Pivot, is there a way, to actually run the entire query with all of the records (outside of what is in the grid) so I can get an actual total? I don’t want to run out of memory since I would be totaling millions of rows. (Using the Pivot table would be easier than rewriting the query to get totals.)

Customer would like the option to modify the pivot table to provide a total result set for a table compared to getting results only for what is in the grid.

All Comments (0) Change History