Pivot Table - Grouping within the page fields.

Hi

I have been tasked with creating a suite of charts which need the facility to "slice and dice" the data. e.g. by year, level, class grade... So a pivot table Chart seems like the obvious choice. This works fine except for a problem. (See attached)

**) I need (If possible) to combine two of the "page" fields. So rather than have two seperate "page" fields for Class and Level, I would like the "page drop" down to show both in one, looking like...

Logic
Math
Science
Language
English
French
German

Meaning that Logic would be Math and Science "rolled-up" and Language would be English, French, and German "rolled-up"

Any help-feedback would be great.

Regards

Ronan