Vertical Label With Column Data either sides

[bandarjm]

Trying to achieve Qlikview Straight table or Pivot. Please suggest.

I have something like this now.

Sales	plan Mtd	ytd
Sales - A	100	2000
Sales - B	2000	777

[dplr-rn]

Need more details my friend.
Share a sample excel and desired output

[bandarjm]

Hope this helps... I need all my MTD  values on left side and YTD on Right side. 

Current:
Label	plan Mtd(Sum)	ytd(Sum)
A	100	1,000
B	2,000	20,000
C	100	1,214
D	1000	20000

Desired

plan Mtd(Sum)	Label	ytd(Sum)
100	A	1,000
2,000	B	20,000
100	C	1,214
1000	D	20000

[dplr-rn]

Just change the order?
You can drag the column header and rearrange.

hope i didnt misunderstand

[bandarjm]

I tried that. May get repeated A,B,C,D values for MTD and YTD, which i dont want.. I am trying ValueList. lets see!! any other suggestions?

[dplr-rn]

Not sure what you mean by repeated.
Dimension will be label And the other 2 expressions?
What happens to table when you just drag and rearrange the column? Can you share a pic?

[bandarjm]

Repeated like this...

[dplr-rn · Accepted solution]

Why do you need a pivot table? On the phone so can't test it but imo you can just change the order by dragging it