Question

Design a view in a map such that if a user selects any state the cities under that state have to show profit and sales.

Answer 1

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.