Answer

Step 1: Create the basic view 

1. Place SUM(Sales) on Columns.
2. Place Product Name on Rows.
3. Place Region on Color.

Step 2: Create Calculated Fields

1. Select Analysis > Create Calculated Field.
2. Name the field. In this example, the field is named Total Sales Per Item.
3. Type the following into the Formula field, then click OK: WINDOW_SUM(SUM([Sales])).
4. Select Analysis > Create Calculated Field.
5. Name the field. In this example, the field is named Rank.
6. Type the following into the Formula field, then click OK: RANK_DENSE([Total Sales Per Item]).

Step 3: Configure Calculated Fields 

1. Drag Rank to Filters.
2. Click OK.
3. Right-click Rank in the Filters shelf.
4. Select Edit Table Calculation.
5. Configure Rank as follows:
   • Select Specific Dimension
   • Move Region above Product Name and check both boxes.
   • At the level: Product Name.
6. Select Nested Calculations > Total Sales Per Item.
7. Configure Total Sales Per Item as follows:
   • Compute using: Region.
8. Click OK.

Step 4: Complete the view

1. Ctrl+Click and drag Rank from Filters to Rows.
2. Right-click Rank in the Rows shelf.
3. Select Discrete.
4. Right-click Product Name in the Rows shelf.
5. Select Sort and configure as follows, then click OK: 
   • Sort order: Descending 
   • Sort by: 
     • Field: Sales 
     • Aggregation: Sum 
6. Right-click Rank on the Filters shelf and select Show Filter.
7. Filter view as desired.

Additional Information