10 Replies Latest reply on Jun 6, 2016 7:20 AM by Mahfooj Khan

    Need help with LOD!

    deepesh.moad

      Hi Guys,

       

      Please help me out with the below problem.

       

      IN the below data, I want show a quick filter like Category -[count of items for that category] and I do not want to show Category field on my report.

      Eg.  Quick filter as Fruits - [4]  ; Veggie - [3]

      Also , when I change the sales slider,count should change in the filter.

      I guess it's possible with LODs ,but I am not able to do so.

        

      CategoryItemSales
      FruitsApple50
      FruitsBanana40
      FruitsPineapple30
      FruitsPeach60
      VeggieSpinach80
      VeggiePotato90
      VeggieOnion40

       

      Workbook attached.

       

      Thanks a million.

       

      Deepesh