4 Replies Latest reply on Dec 10, 2018 2:28 AM by Amit Darak

    Select Top N for one sheet based on other sheet

    Amit Darak

      Hi,

       

      I have created a  dashboard with 2 sheets - One for name and other for company.

       

      I have made a dynamic top 10 filter for company based on sales.

       

      But my aim is - When I click on sheet 1 it should display top 10 in Sheet 2

       

      So if I click on A, it should show top N companies for A. Similarly when I click on B it should show top N companies for B and so on.

       

      Also I have applied various other filters. Will it affect my Top N parameter. I read about context filter, but not getting the result that I want.

       

      PFA packaged workbook.