HOTSPOT (Drag and Drop is not supported)
You have the following dataset.

Yon need to calculate the ranking shown in the Rank field. How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?
- See Explanation section for answer.
Answer(s): A
Explanation:

To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every [Category], which means that the ranking will reset for each category.
Reference:
https://help.tableau.com/current/pro/desktop/en- us/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro/desktop/en-
us/calculations_calculatedfields_lod_rank.htm
Reveal Solution Next Question