Comparative Analysis

[Anonymous]

I have the following chart which i am using for comparative analysis of two groups namely Group A vs Group B:

The expressions for the two groups are as follows:

Now i want to use Moving Annual Totals instead of straight sum to do the comparisons.  I have modified the two expressions to be as follows using the AsOfMonths set analysis:

Amount = ([MedAid Amount] + Shortfall)

However the comparative analysis does not work and i get the following graph:

The MAT values are for the whole data sets and not the respective groups and the two values for Group A and B are the same.  How can i solve my problem.

Regards

Chris

[sunny_talwar · Accepted solution]

May be this:

Sum({[Group A] * $<MonthDiff = {"<12"}>} Amount)

or

Sum({[Group A] * $}*{$<MonthDiff = {"<12"}>} Amount)

[Anonymous]

Thanks Sunny, i used the first expression and it is working

Regards