How to change order of columns in a report

[briantaylor]

I have a use case where I have a custom field called Work Clasisfication that is being used as a Measure and a filter. But I want to have the colums ordered in a specific order

[David_Horne]

Hi @briantaylor you can drag the columns along to where you want them I believe.

Cheers

Dave

[briantaylor]

Dave,

Thanks for the suggestion but that did not work.

[David_Horne]

Sorry mate, I know it works on some of my tables, assumed it was universal. The other way I have done it in the past, was to pick and unpick the columns in the order you want them. It’s a bit painful, but the columns seem to show in the order you have selected them.

Cheers

Dave

[Sebastien_RATEL]

Hi,

What works for me is creating a new member in the “Work Classification” dimension where you aggregate all values in the desired order, then use this member in your report instead of the “all” member.

[nauris.malitis]

Hi @briantaylor !

@David_Horne and @Sebastien_RATEL already have answered your questions, so I’ll just chime in with a link to a Community post that explains the different ways to reorganize the columns when you have several dimensions in the Columns section:

How to change order of columns and rows in the report?

In the report columns and rows, Measures are arranged in the same order as they were added to the report. In columns, you can change measure sequence at any time by dragging and dropping them. The sequence of dimension members (statuses, issue types, sprints etc) is set automatically. To reorder them, use one of the following options. Bookmark dimension members and then add them to the report one by one in the needed order. Create a calculated member in this same dimension with correct me…

Cheers!
Nauris