Tuesday, April 03, 2012 1:03 AMHi,
I am working on a report in Excel 2007 which is getting data from Analysis Services Cube. There are also few hierarchies being displayed on the
Presently only two hierarchies are being displayed on the report and they should appear in separate columns.
When the Hierarchy2 is added to the report, it is added below the Hierarchy1 instead of being added as a separate column. Also when I expand the Hierarchy1 to the lowest level, the Hierarchy2 appears in the next column of the report.
The requirement is to have the second scenario in all the cases, i.e., no matter what level of Hierarchy1 is selected, the Hierarchy2 should always appear in a separate column.
Any help or suggestions will be highly appreciated.
Thanks in advance.
Wednesday, April 04, 2012 1:56 AMModerator
Hi Mohnish,Thank you for posting.
I will help you involve others to help you. There might be some delay about the response. Appreciate your patience.
Bruce Song [MSFT]
MSDN Community Support | Feedback to us
Wednesday, April 04, 2012 8:59 PMModerator
After researching this for some time, I have not found a way to do this. Hierarchies are arranged, by default, one above the other. If this is an urgent request you might consider opening a support ticket with Microsoft.
Microsoft Excel Support