Move column in pivot table

[#1]

Hello everyone,

On the image attached I have several columns that are dimensions. The last column (the one on the right) comes from a expression.

I would like to know how I can change the expression column to the left, to be the first column.

Thank you in advance!

[#2]

Hi Ivo,

As far as I am concerned for Pivot and Straight tables, you cannot place the expressions at the start(first column) when you have dimensions in the table.

Thanks

Sabal

[ashfaq_haseeb]

Hi,

Go to expression tab and play with promote and demote feature.

Regards

ASHFAQ

[aveeeeeee7en]

You can just do Drag & Drop. Place your Mouse Cursor on Expression Label Header and Hold it and Move the Cursor while holding it and place it where you want.

But Kindly check after placing, it does not affect your Result.

Regards

Aviral Nag

[#5]

Hello guys, thank you for the replies.

@Ashfaq Mohammed: I only have one expression and cannot promote/demote expressions and dimensions.

@Nag Aviral: I drag it to to position I want but when I drop, the column stays on the same place and the title of the column disapears...

@Sabal Saxena: you are probably right!!

Best regards

[ashfaq_haseeb]

Hi,

You can rearrange.

Can you share a sample.

Regards

ASHFAQ

[#7]

Sending the sample

[sorrakis01]

hi Ivo,

Where's the problem? what do you want to do, exactly?

[ashfaq_haseeb]

Hi,

Have a look at the attached images.

You just need to drag columns, by selecting column header for dimensions only.

You cannot drag expression column to be as a first one.

Regards

ASHFAQ

[sorrakis01]

Hi Ivo,

You can't put the expresion in the first position,

Regards.