Challenge: Comparing California and New York to Other States

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:

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.