13 Replies Latest reply: Sep 13, 2018 3:09 PM by Vishwarath Nagaraju RSS

    Ignore a filter on set analisis

    Felipe Andrade



      I have a chart that has various values by month. and I have a table that outputs the sum of everything. So I want to use a Month filter that affects the table without losing the chart data.


      here is my equation:

      =if(WildMatch(  [DRE.Competência]  ,'*2018*'),{<  [DRE.Competência]  =>}  [DRE.Competência]  )


      this field is the dimension on the chart that refers to the Month. This equation gives me an error. So this is what i am using right now:

      =if(WildMatch(  [DRE.Competência]  ,'*2018*'),   [DRE.Competência]  )


      I want this field to not change even with a filter for it.


      Thanks in advance!