Forum Discussion

lyasolis's avatar
lyasolis
Frequent Visitor
9 years ago

Matrix Chart - Date Column Order

Hi,

 

I have a Matrix Chart with the following columns:

 

UserID |  January 2017  | February 2017  | March 2017 | etc... | Total

 

The values in the month columns are the amount spent by user that month.

 

I would like the columns to be in the following order:

 

UserID | Total |  March 2017 |  February 2017  |  January 2017  | etc..

 

I can't find the way to order the dates in reverse, with most recent month first.

 

Thank you in advance!

 

PS just had an idea of adding a column and indexing the dates in the order I want them - would that be considered a good practice?

3 Replies