2 Replies Latest reply on Apr 21, 2016 3:55 PM by Gene Denny

    Creating a Sub-Total that is DIFFERENCE and not SUM

    Gene Denny

      So, I've posted on this topic before and, since then, have reshaped my data in an effort to get this to work.

       

      Take the attached packaged workbook.

       

      I would like to add a 3rd column to the first pane that reflects the DIFFERENCE between column 1 and column 2.  In other words, for Brody Middle School, I want a third column that is 66.00% - 60.00% or 6.00%.  I believe this is a LOD scenario but, once again, I'm completely stuck.  Any of you masters able to lend a hand?

       

      Here's what my source data looks like (SQL) for Brody: