Question:
How to shut off the Drill Down Values area that appears in upper left of Query results sheet?
Answer:
Excel-hide the offending rows!
AND/OR
Or don't use any free characteristics!!
_________________
Keep smiling
Answer:
The characteristics that show are not free characteristics, they are rows.
There are no free characteristics.
Answer:
That is the default behavior of Bex, if you want that to not be shown, you would have to save the query in the workbook and simply cut out that area. I do not believe there is a way to turn that off in a query by default.
I am almost positive that you cannot define that in a query, it is functionality attached to the workbook.
- Stephen
Answer:
As I said, use Exel function to hide the rows
SR
(not logged in)