Problem with rolling months on total

[#1]

Hi all,

I need to calculate a market share for a group of products for each month and I'm using a formula like this:

=Sum({<year=,PeriodDate={">=$(=AddMonths(Max(PeriodDate),-12)) <=$(=Max(PeriodDate))"}>} CValue)

/

Sum( total <PeriodDate> CValue)

I have two dimensions, PeriodDate + the group of products, that's why I need the the total part.

The problem is on the underlined part: I'd need it to have the total for each month but it keeps showing me the total only for the last month.

Do you guys have any suggestion? That would be much appreciated.

Thanks for your help,

Lucia

[cesaraccardi · Accepted solution]

Hi Lucia,

What if you copy the set analysis expression to the total calculation:

=Sum({<year=,PeriodDate={">=$(=AddMonths(Max(PeriodDate),-12)) <=$(=Max(PeriodDate))"}>} CValue)

/

Sum( total <PeriodDate> {<year=,PeriodDate={">=$(=AddMonths(Max(PeriodDate),-12)) <=$(=Max(PeriodDate))"}>}CValue)

[ramoncova06]

The total qualifier only gives you the selected month, could your issue be related to that ?

the following post give more details into using total The Aggregation Scope

[#4]

Thank you Cesar,

this was exactly the problem!