
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Comparative Analysis
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this:
Sum({[Group A] * $<MonthDiff = {"<12"}>} Amount)
or
Sum({[Group A] * $}*{$<MonthDiff = {"<12"}>} Amount)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this:
Sum({[Group A] * $<MonthDiff = {"<12"}>} Amount)
or
Sum({[Group A] * $}*{$<MonthDiff = {"<12"}>} Amount)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Sunny, i used the first expression and it is working
Regards
