1 Reply Latest reply on Jun 17, 2016 3:23 PM by diego.medrano

    How to display sum of quarters as MAT to compare current with previous MAT

    Mariya Teneva

      Hi,

       

      How to display a sum of quarters as MAT to compare current with previous MAT, so when we receive every new quarter update, the current MAT can be updated automatically.

      Example: compare MAT Q1 2016 ( Q2 + Q3 +Q4 2015+ Q1 2016) vs. MAT Q1 2015 ( Q2 + Q3 +Q4 2014+ Q1 2015).

      We do not want to see the Quarter- details, but only the sum MAT.

       

      If we use WINDOW_SUM plus (table across) table calculation, then we see the details of the Qs which we don't want to see.

      If we use an if statement incl the TimeKey, this is not an automated approach and everytime we have to change the time key in ' ".

       

      Please advice,

      BR, Mariya