Reorder data sequence in columns
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?
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.