1 Reply Latest reply: Aug 16, 2017 9:29 AM by Sunny Talwar RSS

    Ignoring Specific Filters

    Albert Estrada



      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



      Fiscal Month




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