how do i get dimension in column rather than row format?

[dmxmikey]

I need to get the cust code next to the customer

Cust code          Customer

2469                    Mr & Mrs

2480                    Donald

[alexandros17]

IN presentation tab of your chart there is a check box "Horizontal" check it and let me know

[dmxmikey]

Don’t seem to have that option

Delivering the best in Foodservice...

[#4]

Hi, this option is present in straight table not in pivot chart.

[Peter_Cammaert · Accepted solution]

In a pivot table, just grab each dimension and expression header until the cursor changes into a blue arrow, and drag the arrow to the other side. In this way, you can turn expression into rows, and dimensions into columns.

Option "Allow Pivoting" must be checked in Object Properties->Presentation

Peter

[jpenuliar]

Agree

[#7]

Hi,

Create straight table and you will get this option in presentation tab.

[dmxmikey]

Thank you all for your help