# Apply markup to a specific service

**Objective:** Add or subtract a percentage from the cost of a specific service.

**Use case:** Create a visualization to show the service cost, adjusted by subtracting or adding a fee.

**SQL:**

```sql
CASE
    WHEN "product/productname" = 'Amazon Elastic Compute Cloud' THEN (
        CASE
            WHEN MONTH("lineitem/usagestartdate") = 1
                 AND YEAR("lineitem/usagestartdate") = 2025 THEN 1.16
            WHEN MONTH("lineitem/usagestartdate") = 2
                 AND YEAR("lineitem/usagestartdate") = 2025 THEN 1.22
            WHEN MONTH("lineitem/usagestartdate") = 3
                 AND YEAR("lineitem/usagestartdate") = 2025 THEN 1.21
            WHEN MONTH("lineitem/usagestartdate") = 4
                 AND YEAR("lineitem/usagestartdate") = 2025 THEN 1.19
            WHEN MONTH("lineitem/usagestartdate") = 5
                 AND YEAR("lineitem/usagestartdate") = 2025 THEN 1.23
            ELSE 1.20
        END
    )
    ELSE * "lineitem/unblendedcost"
END
```

***
