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

# What to use pivot or straight and how for my example

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 Name Date # Days Since last test Subject Test Value Test Recieved Difference A Tom 1/1/2017 44 Science 50 44 6 A Tom 1/5/2017 23 English 25 20 5 A Tom 1/1/2017 17 Math 30 20 10 Subtotal 105 84 21 B Gale 3/2/2017 126 Science 30 27 3 B Gale 6/3/2017 56 Math 30 22 8 Subtotal 60 49 11 C Erin 3/2/2017 233 Math 25 20 5 C Erin 4/2/2017 77 Science 45 40 5 Subtotal 70 60 10 Grand Total 235 193 42
• ###### Re: What to use pivot or straight and how for my example

I want subtotal to be only shown for Difference not for Test Value or Test Recieved. I want to omit those ones.

 Student# Student Name Date # Days Since last test Subject Test Value Test Recieved Difference A Tom 1/1/2017 44 Science 50 44 6 A Tom 1/5/2017 23 English 25 20 5 A Tom 1/1/2017 17 Math 30 20 10 Subtotal 21 B Gale 3/2/2017 126 Science 30 27 3 B Gale 6/3/2017 56 Math 30 22 8 Subtotal 11 C Erin 3/2/2017 233 Math 25 20 5 C Erin 4/2/2017 77 Science 45 40 5 Subtotal 10 Grand Total 0 0 42
• ###### Re: What to use pivot or straight and how for my example

This is the closest I could get.  I hope it helps.

On the presentation tab, you'll need to make sure Partial Sum is checked.