5 Replies Latest reply on Apr 7, 2017 9:06 AM by Walt Reed

    When comparing two years and ranking them, how can I filter to show the top N for only one year

    William Crowley

      Hello all, I have created a workbook that ranks customers based on 2017 Net Sales and also on 2016 Net Sales. When I put a filter on the ranking to only show 1-100, it shows customers who only had sales in 2016 but were still ranked in the top 100. I only want to see the 2017 top 100, but I can't figure out how to accomplish this. Any thoughts would be greatly appreciated! Thanks.