## Task

Your task is to compare **Sales** and **Profit** from **California** and **New York** against all other states. Follow these steps:

1. Create a calculated field named **"My States"** with the following formula:  
```sql  
IF [State] = 'California' OR [State] = 'New York' THEN 'CA and NY'  
ELSE 'Other States'  
END  
```  
2. Drag the **"My States"** field to the **Rows Shelf**.  
3. Drag the **"Sales"** and **"Profit"** fields to the **Columns Shelf** to create two charts on a single canvas.  

This streamlined beginner course focuses on the essential Tableau skills needed for business intelligence: connecting data sources, working with dimensions and measures, creating interactive visualizations, designing dashboards, and sharing insights. Each chapter includes practical tasks and projects for hands-on learning.

Challenge: Comparing California and New York to Other States

Task