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 ' ".
An if statement is likely your best bet. I don't know of any easy way to automate the process but you would also only be updating this statement every quarter yes?