Grouping your data by columns

§ YOU CAN USE THE LAYER DATA GRID TO GROUP OR PIVOT YOUR DATA BY ONE OR MORE COLUMN.

1.Choose the first column you want to group e.g. PROVINCE.

2. Right click the column name and click GROUP BY THIS COLUMN. (Or you can just drag and drop the column name into the

  group box.)

3. Your data will now be grouped by the column you selected.

4. Right click the dark grey row below any of your group layers and choose to get a count or sum etc. for that column.

5. You can expand any of your group layers to display the rows that make up a group.

6. Click the drop down arrow next to the group name to expand the group.

7. Right click the column name to add another column to your group box.

8. Click GROUP BY THIS COLUMN or simply drag and drop the column name into the group box.

9. Your first group will now be split into a second group.

10. To clear your groups at any time right click the group box and click CLEAR GROUPING.