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

    Ignoring Specific Filters

    Albert Estrada

      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])