1 of 1 people found this helpful
You can create a calc like this:
SUM ( if [Year] = [user selected year from parameter] then [Sales] END )
And RANK that. (You can actually do it all in one calc.)
And if you just want to hard code 2016 in there, of course you can do that, but using some selection method adds to the usability of the viz...
Filter for top-10 of the RANK. Make a viz that sums up all sales for the past 3 years, and you have 3-year-sales for Top-N customers based on 2016 data.
Of course. Thank you so much.