Spreadsheet: 79921d1280176985-pivot-table-pivotexample
Sheet: Data

Code | Rate | Week | Hrs | Amt
111 | 79.22 | 1 | 1 | 79.22
777 | 20.25 | 1 | 20.25 | 1604.205
222 | 56.33 | 1 | 10.5 | 831.81
123 | 45.66 | 1 | 5 | 396.1
111 | 22.33 | 1 | 6 | 475.32
333 | 88.99 | 1 | 7 | 554.54
111 | 56.66 | 1 | 8 | 633.76
444 | 45.55 | 1 | 8.5 | 673.37
111 | 48.99 | 1 | 10 | 792.2
456 | 45.66 | 1 | 5 | 396.1
111 | 78.99 | 1 | 4.5 | 356.49
103 | 45.55 | 1 | 8.5 | 673.37
101 | 48.99 | 1 | 10 | 792.2
101 | 45.66 | 1 | 5 | 396.1
192 | 78.99 | 1 | 4.5 | 356.49
456 | 20.25 | 1 | 20.25 | 1604.205
999 | 56.33 | 1 | 10.5 | 831.81
222 | 45.66 | 1 | 5 | 396.1
248 | 22.33 | 1 | 6 | 475.32
777 | 88.99 | 1 | 7 | 554.54
123 | 78.99 | 1 | 4.5 | 356.49
333 | 78.99 | 1 | 4.5 | 356.49
111 | 79.22 | 2 | 2 | 158.44
777 | 20.25 | 2 | 7 | 554.54
222 | 56.33 | 2 | 8 | 633.76
123 | 45.66 | 2 | 8.5 | 673.37
111 | 22.33 | 2 | 10 | 792.2
333 | 88.99 | 2 | 5 | 396.1
111 | 56.66 | 2 | 4.5 | 356.49
444 | 45.55 | 2 | 25.5 | 2020.11
111 | 48.99 | 2 | 37.5 | 2970.75
456 | 45.66 | 2 | 22.5 | 1782.45
111 | 78.99 | 2 | 19.5 | 1544.79
103 | 45.55 | 2 | 25.5 | 2020.11
101 | 48.99 | 2 | 37.5 | 2970.75
101 | 45.66 | 2 | 22.5 | 1782.45
192 | 78.99 | 2 | 19.5 | 1544.79
456 | 20.25 | 2 | 7 | 554.54
999 | 56.33 | 2 | 8 | 633.76
222 | 45.66 | 2 | 8.5 | 673.37
248 | 22.33 | 2 | 10 | 792.2
777 | 88.99 | 2 | 5 | 396.1
123 | 78.99 | 2 | 19.5 | 1544.79
333 | 78.99 | 2 | 19.5 | 1544.79
111 | 79.22 | 3 | 3 | 237.66
777 | 20.25 | 3 | 14.75 | 1168.495
222 | 56.33 | 3 | 16.5 | 1307.13
123 | 45.66 | 3 | 22.5 | 1782.45
111 | 22.33 | 3 | 7 | 554.54
333 | 88.99 | 3 | 8 | 633.76
111 | 56.66 | 3 | 8.5 | 673.37
444 | 45.55 | 3 | 10 | 792.2
111 | 48.99 | 3 | 5 | 396.1
456 | 45.66 | 3 | 4.5 | 356.49
111 | 78.99 | 3 | 12.5 | 990.25
103 | 45.55 | 3 | 10 | 792.2
101 | 48.99 | 3 | 5 | 396.1
101 | 45.66 | 3 | 4.5 | 356.49
192 | 78.99 | 3 | 12.5 | 990.25
456 | 20.25 | 3 | 14.75 | 1168.495
999 | 56.33 | 3 | 16.5 | 1307.13
222 | 45.66 | 3 | 22.5 | 1782.45
248 | 22.33 | 3 | 7 | 554.54
777 | 88.99 | 3 | 8 | 633.76
123 | 78.99 | 3 | 12.5 | 990.25
333 | 78.99 | 3 | 12.5 | 990.25
111 | 79.22 | 4 | 1 | 79.22
777 | 20.25 | 4 | 4.5 | 356.49
222 | 56.33 | 4 | 5 | 396.1
123 | 45.66 | 4 | 5 | 396.1
111 | 22.33 | 4 | 6 | 475.32
333 | 88.99 | 4 | 7 | 554.54
111 | 56.66 | 4 | 8 | 633.76
444 | 45.55 | 4 | 8.5 | 673.37
111 | 48.99 | 4 | 10 | 792.2
456 | 45.66 | 4 | 10.5 | 831.81
111 | 78.99 | 4 | 20.25 | 1604.205
103 | 45.55 | 4 | 8.5 | 673.37
101 | 48.99 | 4 | 10 | 792.2
101 | 45.66 | 4 | 10.5 | 831.81
192 | 78.99 | 4 | 20.25 | 1604.205
456 | 20.25 | 4 | 4.5 | 356.49
999 | 56.33 | 4 | 5 | 396.1
222 | 45.66 | 4 | 5 | 396.1
248 | 22.33 | 4 | 6 | 475.32
777 | 88.99 | 4 | 7 | 554.54
123 | 78.99 | 4 | 20.25 | 1604.205
333 | 78.99 | 4 | 20.25 | 1604.205
111 | 79.22 | 5 | 5 | 396.1
777 | 20.25 | 5 | 4.5 | 356.49
222 | 56.33 | 5 | 5 | 396.1
123 | 45.66 | 5 | 7 | 554.54
111 | 22.33 | 5 | 8 | 633.76
333 | 88.99 | 5 | 8.5 | 673.37
111 | 56.66 | 5 | 10 | 792.2
444 | 45.55 | 5 | 19.5 | 1544.79
111 | 48.99 | 5 | 22.5 | 1782.45
456 | 45.66 | 5 | 37.5 | 2970.75
111 | 78.99 | 5 | 3.75 | 297.075
103 | 45.55 | 5 | 19.5 | 1544.79
101 | 48.99 | 5 | 22.5 | 1782.45
101 | 45.66 | 5 | 37.5 | 2970.75
192 | 78.99 | 5 | 3.75 | 297.075
456 | 20.25 | 5 | 4.5 | 356.49
999 | 56.33 | 5 | 5 | 396.1
222 | 45.66 | 5 | 7 | 554.54
248 | 22.33 | 5 | 8 | 633.76
777 | 88.99 | 5 | 8.5 | 673.37
123 | 78.99 | 5 | 3.75 | 297.075
333 | 78.99 | 5 | 3.75 | 297.075
111 | 79.22 | 6 | 6 | 475.32
777 | 20.25 | 6 | 7 | 554.54
222 | 56.33 | 6 | 8 | 633.76
123 | 45.66 | 6 | 8.5 | 673.37
111 | 22.33 | 6 | 10 | 792.2
333 | 88.99 | 6 | 5 | 396.1
111 | 56.66 | 6 | 4.5 | 356.49
444 | 45.55 | 6 | 2.5 | 198.05
111 | 48.99 | 6 | 3.5 | 277.27
456 | 45.66 | 6 | 4.5 | 356.49
111 | 78.99 | 6 | 19.75 | 1564.595
103 | 45.55 | 6 | 2.5 | 198.05
101 | 48.99 | 6 | 3.5 | 277.27
101 | 45.66 | 6 | 4.5 | 356.49
192 | 78.99 | 6 | 19.75 | 1564.595
456 | 20.25 | 6 | 7 | 554.54
999 | 56.33 | 6 | 8 | 633.76
222 | 45.66 | 6 | 8.5 | 673.37
248 | 22.33 | 6 | 10 | 792.2
777 | 88.99 | 6 | 5 | 396.1
123 | 78.99 | 6 | 19.75 | 1564.595
333 | 78.99 | 6 | 19.75 | 1564.595