- Drag and drop Country from Dimension onto Detail in the Marks card.
- Drag and drop Points from Measures onto Color in the Marks card.
- Right-click on the SUM (Points) pill in Color, navigate to Measure (Sum), and from the drop-down menu, select Average.
- Create a new blank worksheet by clicking on the New Worksheet tab at the bottom of the workspace. Alternatively, in the main menu toolbar, navigate to Worksheet | New Worksheet from the drop-down menu.
- In the new worksheet, drag and drop Country from Dimensions onto Color in the Marks card. A dialog window may pop up, asking you if you would like to filter out some of the countries. Select Add all members:
- Drag and drop Province from Dimensions onto Detail in the Marks card. ...