Vertical Dimension into horizontal

[#1]

Dear All,

I am facing a problem with some reports I have been trying to create.

I have the following object.

And in order to make the report more user-freindly and easier to read I would like it to look like this;

Here, the Balances B and F are grouped under each the Assets and Liabilities.

I have searched in the forums and found these two solution, but I have not been able to work any of them.

http://community.qlik.com/forums/t/19453.aspx

http://community.qlik.com/forums/t/30084.aspx using a macro, though i would prefer not to use one

Is there any way where I can use a merged header or something of the like where both balance B and F are grouped under Assets at the and under liabilities as well.

Or if someone could tell me how to use the NumberOfLeftDimensions property, then that would be af great help.

Looking forward for your replies, thanking you in advance.

Best Regards,

Sadri

[#2]

Hi,

Try with a pivot table... There you can convert horizontal column into a vertical column...

Regards,

Nilupa

[#3]

Hi,

Thanks for your reply.

I've tried doing it with a pivot table, but I couldnt figure out how to.

Can you give me any pointers?

Regards,

Sadri