I don't think this is possible, however I was told by someone they did it. Here's the scenario
We have a query which uses a BEx Structure in the row section as follows:
Row1: Cost Centers (Custom grouping)
Row2: Total
When executing query in BEx Analyzer Excel, we want to perform a drilldown on Row1, but NOT Row2.
If Row1 is made up of 50 Cost Centers, after drilldown I should only be able to see 51 rows.
What is happening now we see 100 rows when we drilldown on CC, this is because both Row1 and Row2 are expanded.