Filtering by calculated fields
In the previous section, we talked about different types of filters. In this section, we will focus on discussing different use cases of filtering by calculated fields.
Now let's look at an example of using
Rank() table calculation to filter the top product sub-categories for each order year in the Superstore data set.
- Drag Order Date to Rows, and set as Year (Order Date).
- Drag Product Sub-Category to Rows.
- Drag SUM (Sales) to Columns. You will see the following:
- The goal is to look at the top five product sub-categories for each order year, based on sales. To achieve this goal, we duplicate SUM (Sales) by dragging ...