Create a calculated field to calculate the total sales for each customer in 2021.
Sort the customers by total sales in descending order.
Create a table visualization with the customer name and total sales.
Use the table calculation to calculate the rank of each customer in terms of total sales.
The 25th, 50th, and 100th customers from top will be the customers with the ranks 25, 50, and 100, respectively.
Here is an example of how to do this in Tableau:
Create a calculated field called Total Sales in 2021 using the following formula:
SUM(Sales)
Drag the Customer Name field to the Rows shelf.
Drag the Total Sales in 2021 field to the Values shelf.
Click the Sort button on the Total Sales in 2021 header and select Descending.
Click the Table Calculation button on the Total Sales in 2021 header and select Rank.
In the Table Calculation dialog box, select Customer Name for the By field and Total Sales in 2021 for the Then by field.
Click OK to close the dialog box.
You will now see a table visualization with the following columns:
Customer Name
Total Sales in 2021
Rank
The 25th, 50th, and 100th customers from top will be the customers with the ranks 25, 50, and 100, respectively.
You can also use the table calculation to create a filter to show only the top 25, 50, or 100 customers. To do this, drag the Rank field to the Filters shelf and select the desired ranks.
For example, to show only the top 25 customers, you would select the ranks from 1 to 25.
Once you have created the filter, you can apply it to the visualization to see only the top 25, 50, or 100 customers.f
Thank you
