Creating a Single Label for a Custom Region

Step 1: Calculate the sales per region using a Fixed Level of Detail calculation

1. Select Analysis > Create calculated field.
2. Name the calculated field "Sales by Region" and enter the following formula:

   { FIXED [Region]: SUM([Sales])}

Step 2: Create a calculated field to eliminate Duplicate Labels

1. Select Analysis > Create calculated field.
2. Name the calculated field "Label Text" and enter the following formula:

   IF INDEX() = 1 
   THEN MAX([Sales by Region]) 
   END 

Step 3: Build the view

1. Double-click the "State" dimension.
2. Drag "Region" to Color on the Marks card.
3. Drag "Label Text" to Label on the Marks card.
4. Right-click on the Label Text field and select Compute Using > State.