How do you use dimension in column?

[#1]

I am using a pivot table and wish to use another dimension in columns. Effectively dimensions in both rows and columns. Can someone provide a sample code / steps of how to achieve this in Qlikview.

[lironbaram]

hei you just need to make sure

that in the chart properties in the presention tab

the "allow pivoting" is checked

then you just drag the dimension you want to use as column up

you will see a blue arrow as it changes from vertical to horizontal

[#3]

I will need to explain my problem in detail.
I want the pivot table to look like this. I need aggregation of hours by level for a given SBU. Both Level and SBU are dimensions. Std Hours and Paid Vac are based on type of hours booked.

SBU #1        SBU#2       SBU#3 ...
Std Hours
Level 1
Level 2
Level 3
Paid Vac
Level 1
Level 2
Level 3

Thanks.

[lironbaram · Accepted solution]

hei

check the example hope it helps you

[#5]

Thanks for your prompt support. Very useful.