3 Replies Latest reply: Apr 4, 2018 3:48 PM by Carlos Monroy RSS

    Match Function Issue with Filtering

    scott dealtrey

      Hello,

      I am grouping my sales codes (being used as dimensions) into certain categories. I am using this all in a drill down master dimension.

       

      The issue I am running into is that our company has a sales code "051" and "51". When I am using the following function -

       

      if(MATCH(SALE_CD,'051'),'RETREADS',

       

      Both the "051" and "51" codes are being included. Unfortunately "51" is a in a different category than "051".


      Is there a different function other than match that I could use to group these dimension?


      Thanks