I have created a query that produces multiple result sheets.
However, when I try to export the results either by saving as a spreadsheet or by exporting to excel I am only allowed to export/save one result sheet at the time. Has anyone a useable workaround? I guess that I should redesign my query to output raw data to excel and to the real analysis there.
The reason for the multiple output sheets is that it isnt possible to filter objects. This is another major issue with the query engine. Are there any plans in adding that kind of bread&butter functionality?