4 Replies Latest reply on May 15, 2013 12:02 AM by Chris Turnbull

    How to Setup Column and Compare 2 Dimensions in One Cell?

    Chris Turnbull

      Hi All,

       

      In the attached workbook I have 2 Dimensions cmg and pmg which are student grades (*, a, b, c, d, e, f, g, u) and I want to compare the count of each grade for each subject with the cmg being on top of the pmg - I will then Colorise depending on whether the cmg count is above or below the pmg count.  I will then total and percentage each line for categories *-C and *-G.

       

      The issue that I am having is that I do not know how to setup the column shelf with the grades.

       

      Any help greatfully received.

       

      Thanks

       

      Chris