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

    Top Value per Dimension?

    d 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