2 Replies Latest reply on Aug 17, 2016 1:36 PM by Keshia Rose

    Totals Question

    Antoinette Van Demark

      Hello,

       

      I am working on a worksheet where I am using the Color option for marks.

       

      A sample of the data shows student enrollment by grade and school. I used the color option showing the count of females as pink and males as blue. Since there are only 2 options, I would actually like to show the total and then the breakdown.

       

      For example-- For the first row of Grade 1 at school S001 display  6 (4 2) or 4 2 (6) or some other variation. Similarly, I would like to do the same for the sub-totals and grand total.

       

      Is something like this possible??

       

      Thank you,

      Antoinette