3 Replies Latest reply on Nov 28, 2016 5:46 AM by Simon Runc

    Dynamic Top N and Others

    Udayambika Nair

      Hi All,

       

      i m trying to achieve a dynamic TOP n and "others" which changes as per the filters selected using the other sheets in the dashboard.

      Used set and parameter to create TOP N and other.,However when i select the a particular category from the sheet below i.e sheet 3 top 9 customers are filters out from the top 9 customers at the data level not at the category level or the sub category level. what i get is at sheet 2. filters at category and sub category level applied on sheet 3 and  sheet 4 respectively

      .

       

      the required result is showcased in sheet 5.

      Please help.

      attached is the workbook

       

      Regards

      Amby