4 Replies Latest reply on May 20, 2018 5:30 PM by Jane Wong

# Matrix based on different periods of same dimension

Hi

I am trying to create a matrix. Column is current month and corresponding Company grade in the month, and row is always 3 months before current month and company grade in that month. In my example, Column is Dec 17 and row is Sep 17.

The number in the matrix is company order in Dec 17.

I have created previous 3 months in calculated field, but it seems it always pick up Dec 17 Company grade for both Dec17 and Sep 17.

Many thanks,

Jane

• ###### 1. Re: Matrix based on different periods of same dimension

Hi, Jane

Can you explain more about how do you calculate the highlighted number below?

ZZ

• ###### 2. Re: Matrix based on different periods of same dimension

Hi Zhouyi

Total number of C is 400 in Dec 17 (200 is from Australia ABC and another 200 is China SION), Australia ABC company grade was A in Sep 17 and China SION company grade was E in Sep 17), hence it is 200 showing in highlighted.

Thanks a lot.

Jane

• ###### 3. Re: Matrix based on different periods of same dimension

Hi, Jane

1st, left join your data to itself by date and a calculation field as shown below

2nd, create a calculation field and build view like below

Hope this helps

ZZ