$$ Go to the Year End Data$-$worksheet Create a custom sort$-$list to sort the provinces. The custom sort$-$list shouldorder Provinces by British Columbia, Alberta, Saskatchewan, $-$Manitoba$-$and$*$Ontario$,-1$I

$$ Using$-$the data$-$on the$-$YYear.End$-$Data worksheet, create$-$a$-$PivotTable with the results on a new worksheet to summarize the data by $-$Province rows using $-$ Total Sales. Modify the Value column to display the result$-$as the $\%.$ of$-$Grand$-$Total. $-1$ above$-$British Columbia to$-$West$-$Region. Select$-$the$-$Saskatchewan, Manitoba and Ontario$-$text $($not the grouping titles$)$ and add a Group Selection. Name the new$-$group. West$-$Central Region. II