Tableau practice: Ranking, distributions and table filters

Create Rep Rank: rank each Sales Rep by total Sales, where 1 is the biggest: RANK(SUM([Sales])).

Create Top Rank: rank reps by total Sales (1 = largest). The view filters on your field to keep only ranks 1 to 3.

If two sales reps tie for rank 1, what rank number does standard RANK() assign to the third representative?

Create Mark Index: return the physical position index (1, 2, 3...) of each mark within its partition using INDEX().

Create Dense Rank: rank product categories by total Sales using consecutive numbering with RANK_DENSE(SUM([Sales])).