Hi Sabaritha
This will only work if you embed a blank member in the hierarchy of the members. Then you can use a conditional formula to format the blank row accordingly. But I have to admit, I'm not a big fan of changing the metadata for reporting purposes.
Without changes to the hierarchy, and keeping the drillability in takt, this is the best I get:
The dimension with the tree command needs to be in the second (or 3rd, or 4th) expansion level and then the you can hide the first expansion level by using this setting:
The result will look like this:
If you use conditional formatting smart, you will still be able to create a nice-looking cubeview.
I hope this helps and cheers
Christian
