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



      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.