5 Replies Latest reply: Dec 6, 2016 9:42 AM by Simon Goodman RSS

    Selected Filter pane is showing if conditions

    sreeranga prasad

      Hi all

       

      i written calculated dimension based on my requirement

       

      i have 10 types of modes(types) in database

       

      my require is to show only 3 types in filter for that i wrote

       

      if(Mode= 'Misc', 'All Other',

      if(Mode= 'Parcel', 'All Other',

      if(Mode= 'ProMexdome', 'All Other',

      if(Mode= 'Waretest3', 'All Other',

      if(Mode= 'Airtest', Mode,

      if(Mode= 'Intmodalte', Mode,

      if(Mode= 'Truckload', Mode,

      ) ))))))

       

      result is

      Airtest

      Intmodalte

      Truckload

      All Other


      Issue is

      error2.png

      how to rectify this one i am expecting to see mode only as text