Excluding Field Selection from 12-Month Rolling Sum

[BU]

Hi everyone,

I have a chart that calculates a 12-month rolling SellOut using the following formula:

{<[Famiglia.Raggruppamento]={'Industriale'}>}
RangeSum(Above(Sum([#LV_DT_EC.Venduto]),0,12))

It seems to be working fine.

NOTE: The chart is sorted using the concatenation of PROJECTS.Year & PROJECTS.Month.

However, users need to navigate through the app by selecting a field called PROJECTS.YearMonth, but I want to exclude this selection from affecting the chart.

I tried using the following formula:

{<[Famiglia.Raggruppamento]={'Industriale'}, PROJECTS.YearMonth=>}
RangeSum(Above(Sum([#LV_DT_EC.Venduto]),0,12))

The issue is that when I select PROJECTS.YearMonth, the chart changes its sorting order and bar values.

How can I ensure that selecting PROJECTS.YearMonth does not affect the sorting or values in my rolling sum calculation?

Thanks in advance for your help!

[marcus_sommer · Accepted solution]

Ignoring selections of YearMonth have no impact to the fields Year and Month which further react to the selection state. You will probably need to include all period-fields within the set analysis - and maybe not only in the main-expression else also within the calculated dimension and/or any property-expressions, like the sorting.