How to change positions of dimensions in a pivot table

[#1]

Hey,

how can I change the positions of dimensions in a pivot table?

Look at my example, there you can see is the dimension run. Normally the positions are 1, 2, 3 but I want for example the positions 2, 1, 3 or the positions 3, 2, 1. Is there any way to do that?

Thank you

[marcus_sommer]

You could drag and drop with the mouse - vertically and horizontally with left-click on the column-header and then dragging.

- Marcus

[rubenmarin]

[#4]

But I want that a business user should do thtat without scripting.

[marcus_sommer]

Drag and drop could also a user within the browser - it's quite easy. If it's don't work then is this option disabled - you will find it within the object-properties in tab presentation.

- Marcus

[rubenmarin · Accepted solution]

Then you'll need some way the user can input the desired order, maybe using inputfields, check attached file.

[rubenmarin]

Hi Marcus, [Run] is a vertical dimension, If I understand it right Hans is looking to sort the values of the [Run] field.