Find my approach based on two different calculated fields and rank-functionality stored in attached workbook version 9.3 located in the original thread.
Step 1: Define calculated field Sales 2016
if [date]=#1-1-2016# then [value] END
Step 2: Define calculated field Sales 2017
if [date]=#1-1-2017# then [value] END
Step 3: Define Rank
Step 4: Drag defined calculated fields to the right locations.
Rank_nalmai.twbx 36.1 KB
That is a nice approach, hadn't thought of that
Had to create another rank for 2016 so I could drop it to the left and filter the top 10 without filtering data for 2017 rank