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

    Totals Question

    Antoinette Van Demark



      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,