5 Replies Latest reply: May 4, 2018 11:20 AM by Olivier GAUTIER RSS

    Creating an aggregated dimension filter : Urgent requirement

    vishal raina

      Hi,

      This is an urgent requirement. I've the data in the below format and it has data for 10 different brands in the similar manner as given below. I need to create an aggregated dimension out of this which would in turn be used as a filter. The requirement is to create 'Top 3 Brands', 'Top 5 Brands', 'Top 7 Brands','Top 10 Brands'  drop downs from the available data basis sales. So the aggregated dimension should act as a filter with the mentioned drop downs.

       

      BrandsYearSales
      a2017500
      a2017400
      b2017450
      b2017399
      b2016560
      c2016457
      c20171231
      c2017323