3 Replies Latest reply on Jul 26, 2016 2:48 PM by Shinichiro Murakami

    Nested Table Calculation Help - Difference From (QoQ) on a Percent of Total

    R Olsen

      Hi, hope someone can help with this.  I am trying to do a nested table calculation and it's not working quite the way I am expecting.  I am trying to determine the difference between quarters of particular grades by Percent of Total (Table Down).  Here is what I have so far.  The row in orange is the row I am trying to achieve, but can't.  Any help you can provide would be greatly appreciated!

       

      Thanks in advance,

      R

       

      GroupCategoryQ2Q3
      A-E

      Grade Count

      Difference between Qtrs

      % of Grade per Quarter

      Difference between Qtrs

      32

       

      17.2%

      33

      1

      17.4%

      .2%

      F

      Grade Count

      Difference between Qtrs

      % of Grade per Quarter

      Difference between Qtrs

      44

       

      23.7%

      48

      4

      25.3%

      1.6%

      G-H

      Grade Count

      Difference between Qtrs

      % of Grade per Quarter

      Difference between Qtrs

      57

       

      30.6%

      58

      1

      30.5%

      (0.1%)

      I-J

      Grade Count

      Difference between Qtrs

      % of Grade per Quarter

      Difference between Qtrs

      37

       

      19.9%

      36

      (1)

      18.9%

      (1.0%)

      K-L

      Grade Count

      Difference between Qtrs

      % of Grade per Quarter

      Difference between Qtrs

      13

       

      7.0%

      12

      (1)

      6.3%

      (0.7%)

      M

      Grade Count

      Difference between Qtrs

      % of Grade per Quarter

      Difference between Qtrs

      3

       

      1.6%

      3

      0

      1.6%

      0.0%