If you want to show the profit and sales of each and every city under the state in the same worksheet, then follow a few steps.
The data which you want to display under the state, it must be in the same worksheet.
- Double click on the state filed.
- Drag the city and drop it under the state(Mark Card).
- Drag the Sales and drop into the size.
- Drag the Profit and drop it into the color.
- Click on the size legend and increase the size (75%).
- Give a right-click on State filed and select show filter.
- Select the state and check whether you got the required view or not.