Ignoring Specific Filters

[albertestrada]

Hello,

Can someone provide guidance on how to ignore specific filters in a Aggr function & set analysis? I am calculating a 12 month rolling sum of revenue in a bar chart.  I would like for the chart to display the 12 months based on the Month selected.

I would like to ignore Fiscal Quarter and Fiscal Year

Dimension:

Fiscal Month

LVL_2

Measure:

Aggr(RangeSum(Above( sum({<[Fiscal Quarter]=,[Fiscal Year]=,ADJ_CNL_IND_LVL_1={'ACC'}>} REV_AMT),0,12)), LVL_2,[Fiscal Month])

[sunny_talwar · Accepted solution]

Try this

Only({<[Fiscal Quarter], [Fiscal Year]>} Aggr(RangeSum(Above(Sum({<[Fiscal Quarter], [Fiscal Year], ADJ_CNL_IND_LVL_1 = {'ACC'}>} REV_AMT), 0, 12)), LVL_2, [Fiscal Month]))