Reorder data sequence in columns

Hi all,

Below shown the normal sequence of displaying data in Targit with data for several years (see the yellow bar). This sequence is: Revenue 2017, Sales 2017, Revenue 2018, Sales 2018.......

I want to change the sequence (see the green bar) so the sequence is: Revenue 2017, Revenue 2018, Revenue 2019, Sales 2017, Sales 2018, Sales 2019.

Is that possible to do and how? Thank you all :-)



  • The only way I know of, is to create 6 new columns and transport the values in the order you need. But then you have to manually update with new columns, when a new year arise. Not the best solution. 

    As far as I know you can't even change the order of your existing colums by drag & drop.

    Interesting to hear if anyone else have a better solution?

  • Hi Louise,

    Thank you for the input. I have tried the solution and hope for other suggestions, specially because I have to update every week (because my data is shown per week).

    It seems more people are loking for a better solution. Hope that someone can provide it :-)   


Please sign in to leave a comment.

Didn't find what you were looking for?

New post