11 Replies Latest reply on Oct 4, 2016 10:31 PM by Eileen Lee

    Set categories in a Filter List

    Eileen Lee

      HI,

       

      Suppose I have 2 columns as below...

       

      OrangeFruit
      PearFruit
      CeleryVegetable
      LettuceVegetable
      AppleFruit
      BroccoliVegetable
      CabbageVegetable
      TurnipVegetable
      MangoFruit

       

      and I need to create filter list that looks like the one below,

      is it possible? I would still need to see the individual items and respective sales figures if Groups are to be used.

       

      Thank you!