Hi
I am trying to work out the best way to set up a Pivot Chart using the following headings.... There are 800 students (rows)
ID, Year of Entry, Class, Level, 2001, 2002, 2003, 2004, 2005, 2006, 2007
Each Row is a unique Student, and the other data is as follows;
Year of Entry = 1998 - 2001
Class = Math, English, German etc...
Level = Honours, Advanced, Introduction
And for each of the "Year" columns (2001,2002 etc...), their could be grades such as Good, Exceeded, Outstanding, Average, No Rating.
So I think what I want to do is either have the User choose which "Year" of Grading to look at, or count how many "Good", "Exceeded" etc... for each of the "Years".
Thanks
Ronan
Bookmarks