Beyond 20/20 Sorting Question

Question

With regard to census data, if I only want the top Province level data in any given file - how would I do that without selecting each line separately? Is there a trick here? Right now - as far as I'm aware the only way to obtain this would be to hold my Ctrl button done, scroll through the file and select each province.

Answer

1. Make the "Geography" dimension active.
2. Click on that double-arrowed "Sort" icon above.
3. Choose "Code" & "Increasing Numeric" and "Ok".

The result should be Canada, then all provinces, then all territories.

You can also find a B2020 Help Sheet at
http://www.library.carleton.ca/ssdata/surveys/b2020.html along with links to the B2020 User Guides.