Need Help: Show latest month first in matrix instead of last

[santoshlearner2]

Hello,

I want to show a trend of sales, using matrix visualizations, say of last x months or based on the user selection, But the issue is the latest months shows on the right hand side alongwith the total next to it, I wanted to show it at the start .  Thank you all in advance. Warm Regards. 

It shows like this
Employee Name	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	Total
x	100	20	30	40	50	60	70	80	90	10	12	42	12	616
y	40	50	60	70	40	50	60	70	40	50	60	70	12	672
z	90	10	12	42	90	10	12	42	90	10	12	42	12	474
Wanted like this
Employee Name	Apr-24	Mar-24	Feb-24	Jan-24	Dec-23	Nov-23	Oct-23	Sep-23	Aug-23	Jul-23	Jun-23	May-23	Apr-23	Total
x	12	42	12	10	90	80	70	60	50	40	30	20	100	616
y	12	70	60	50	40	70	60	50	40	70	60	50	40	672
z	12	42	12	10	90	42	12	10	90	42	12	10	90	474

[Anonymous · Accepted solution]

Hi @santoshlearner2 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

(2) We can enter data.

Month-Year	Index
Mar-23	14
Apr-23	13
May-23	12
Jun-23	11
Jul-23	10
Aug-23	9
Sep-23	8
Oct-23	7
Nov-23	6
Dec-23	5
Jan-24	4
Feb-24	3
Mar-24	2
Apr-24	1

(3) We can then create a model relationship.

(4) Select Table 2, select the [Month-Year] column, and select Sort by the Indexed Column.

(5) Create the matrix as shown below.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Ashish_Mathur]

Hi,

You should be able to sort by months in descending order.

[Anonymous · Accepted solution]

Hi @santoshlearner2 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

(2) We can enter data.

Month-Year	Index
Mar-23	14
Apr-23	13
May-23	12
Jun-23	11
Jul-23	10
Aug-23	9
Sep-23	8
Oct-23	7
Nov-23	6
Dec-23	5
Jan-24	4
Feb-24	3
Mar-24	2
Apr-24	1

(3) We can then create a model relationship.

(4) Select Table 2, select the [Month-Year] column, and select Sort by the Indexed Column.

(5) Create the matrix as shown below.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[santoshlearner2 · Accepted solution]

Hi 

Perfect, thank you for your reply. 

Thanks a lot