I have data that is arranged like this:

http://i.stack.imgur.com/R8dv7.jpg

The actual dataset is significantly larger, but this is a good representation.

I want to create a time series PivotChart for this data, with the names ("TD, RBC, BARC, BNP" etc) as filters so that the user can hide or reveal whatever series are relevant.

However, with several hundred companies listed, it might be tedious for the user to manually click on the filter for each one. So I'd want to group them together, so that clicking on a "CANADA" filter for example automatically selects TD, RBC, BMO etc. However I'm not sure how to group together filters like this.

If I make a Pivot Table selecting the range shown in the picture above, the fields provided are:

http://i.stack.imgur.com/StvEk.jpg

How can I group the filters together so that I can hide/reveal the series the way that I want to?