Challenge: Analyzing Bookcase Profit Concentration

Task

Your task is to determine whether profit from bookcases is concentrated in California and New York.

1. Right-click on the "State" field and select Create > Set....
2. Name the set (e.g., "CA and NY") and select the states California and New York.
3. Drag the "Sub-Category" field to the Columns Shelf and "Sales" to the Rows Shelf.
4. Move the newly created set (e.g., "CA and NY") to the Color area in the Marks section to differentiate between the selected states and other states.
5. Add "Profit" to the Rows Shelf to create a second chart on the same canvas.