3 Replies Latest reply: Jun 6, 2016 8:48 AM by Pravesh Dukhi RSS

    Display only certain values on a filter pane

    luca ganugi

      Hi guys,

      i'm trying to filter some values on a filter pane with a expression like this:

       

      if(

      aggr(sum(FIELD1),FIELD2)>0,FIELD 3,

      )

      It works, but instead of selecting only the FIELD3 on the top active filter it select also FIELD2.

       

       

      In another example:

       

      if(aggr(sum(FIELD1),FIELD2)>0,FIELD 3 & ' ---- ' & FIELD4,

      )

      it will add also FIELD4 on the active selections...

       

       

      how can avoid this? I want only to have on the top active selections the FIELD3

       

       

      tnx