1 Reply Latest reply on Sep 11, 2019 9:55 AM by Hari Ankem

    category with repeated values

    rao marapatla

      Hi All,

       

      i have a fruits and costs, i wanted to group by multiple fruits share accross other category  - please find attached workbook

       

      like below - Apple and banana are in group 1

                        Apple and Gova are in group 2

                       Apple and mongo are in group 3

       

                      orange and mongo are in group 4

                    grapes and  mongos and apple are in group 5

       

       

      if [Fruits] = 'Apple' or [Fruits] = 'banana' then "group1"

      ELSEIF  [Fruits] = 'Apple' or [Fruits] = 'Gova' then "group2"

      ELSEIF  [Fruits] = 'Apple' or [Fruits] = 'Mongo' then "group3"

       

      end