2 Replies Latest reply on Jul 1, 2016 11:49 AM by Ivan Young

    Top Value per Dimension?

    Darren Vermaak
      CategorySubcategoryValue
      Category 1SubCategory 11000
      SubCategory 23500
      SubCategory 37700
      Category 2SubCategory 182
      SubCategory 2336
      SubCategory 3986
      SubCategory 4546
      Category 3SubCategory 112

       

      Hello,

      How would I filter the top value per each category? What I would like to do is display every category, but only show the top subcategory. When I apply a top filter, it is filtering the categories, so not all of them are displaying. I want every category to be displayed, but only filter the subcategories so that the top value is displayed.

      Like so:

      Category
      SubcategoryValue
      Category 1Subcategory 27700
      Category 2Subcategory 3996
      Category 3Subcategory 112