2 Replies Latest reply: Apr 20, 2017 4:44 PM by Wallo Atkinson RSS

    What to use pivot or straight and how for my example

    m m
      Student#Student NameDate# Days Since last testSubjectTest ValueTest RecievedDifference
      ATom1/1/201717Math302010
      ATom1/5/201723English25205
      ATom1/1/201744Science50446
      BGale6/3/201756Math30228
      BGale3/2/2017126Science30273
      CErin3/2/2017233Math25205
      CErin4/2/201777Science45405
      CErin3/2/201796History35305

       

       

      Require:

      I need subtotal by Student# on Difference. Which should be sorted by # of Days Since Last test.

       

      Question: How do you determine if you need Straight Table or Pivot.

       

      Results: Subtotal By Student# & Grand total at the end + within each student data is sorted by #Days Since last test.

              

      Student#Student NameDate# Days Since last testSubjectTest ValueTest RecievedDifference
      ATom1/1/201744Science50446
      ATom1/5/201723English25205
      ATom1/1/201717Math302010
      Subtotal 1058421
      BGale3/2/2017126Science30273
      BGale6/3/201756Math30228
      Subtotal 604911
      CErin3/2/2017233Math25205
      CErin4/2/201777Science45405
      Subtotal 706010
      Grand Total 23519342