1 Reply Latest reply on Apr 4, 2016 10:25 AM by lenaic.ridinger

    Filtering using top

    Sushma Nayak

      Hi All,

       

      I am using Sample Superstore workbook.

      Filtering.PNG

       

       

      Is there a possibility to get top 2 regions based on sales and in each region top 4 Subcategory based on sales. I tried applying filters  but the issue is it worked fine for regions but when it comes for Subcategory, Top 4 subcategory is calculated for complete spend and is not for specific region. its there any way of achieving this?