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

    Matrix based on different periods of same dimension

    Jane Wong

      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.

       

      I have attached both workbook and what I expected to see. Can someone please help.

       

      Many thanks,

       

      Jane