Need help for the Pivot in Excel 2007

Question

Hi,

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
excel report.

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.

Regards,

Mohnish

Answer 1

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.
Best Regards,

---

Bruce Song [MSFT]
MSDN Community Support | Feedback to us

Answer 2

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.

Will Buffington
Microsoft Excel Support