Comparative Analysis

[Anonymous]

I have the following expression in my comparative analysis:

Sum({[Group A] * $} Amount)

The above is a generalised expression used with a year dimension.  I now need to convert this to be used with a  month-year dimension to give a rolling 12 months figure with the following expression:

Sum({$<MonthDiff={"<12"}>} Amount)

How do I incorporate comparative analysis as per the first expression with this second expression?

Regards.

[Anonymous]

Hi,

Please see this post for an idea on how to do the above: Month on Month Comparison.

[MK_QSL]

What is the format of your MonthYear?

[Anonymous]

Hi Manish

it is as follows, from my calendar

Date(MonthStart(TempDate), 'MMM-YYYY') as MonthYear,

Regards.

[MK_QSL]

Try below

Calculating rolling n-period totals, averages or other aggregations

[Anonymous]

Manish

Many thanks, i have gone through this post.  What i want is to incorporate 'Comparative Analysis' into the expressions

[MK_QSL]

Provide sample data or sample application to work..