Spreadsheet: 152212d1335287949-pivot-tables-sorting-data-into-a-useable-way-to-use-formulas-against-agency-rec-201201-pre-monthend-demo
Sheet: Source - Timesheet costs

Company | Staff ID | Forename | Surname | Staff Accounting Centre | Week Ending Date | Total Salary | Posted Period
1 | 1006 | PAUL | evans | 1 | 2012-03-04 00:00:00 | 447.36 | 201201 |  | Row Labels | Sum of Total Salary
1 | 1006 | PAUL | evans | 1 | 2012-03-11 00:00:00 | 1352.08 | 201201 |  | 1006 | 7605.12
1 | 1006 | PAUL | evans | 1 | 2012-03-11 00:00:00 | -10 | 201201 |  | 2012-03-04 00:00:00 | 447.36
1 | 1006 | PAUL | evans | 1 | 2012-03-18 00:00:00 | 1342.08 | 201201 |  | 2012-03-11 00:00:00 | 1342.08
1 | 1006 | PAUL | evans | 1 | 2012-03-25 00:00:00 | 1230.24 | 201201 |  | 2012-03-18 00:00:00 | 1342.08
1 | 1006 | PAUL | evans | 1 | 2012-04-01 00:00:00 | 1230.24 | 201201 |  | 2012-03-25 00:00:00 | 1230.24
1 | 1006 | PAUL | evans | 1 | 2012-04-08 00:00:00 | 671.04 | 201201 |  | 2012-04-01 00:00:00 | 1230.24
1 | 1006 | PAUL | evans | 1 | 2012-04-15 00:00:00 | 671.04 | 201201 |  | 2012-04-08 00:00:00 | 671.04
1 | 1006 | PAUL | evans | 1 | 2012-04-22 00:00:00 | 671.04 | 201201 |  | 2012-04-15 00:00:00 | 671.04
1 | 1031 | MARTYN | Jones | 125 | 2011-12-11 00:00:00 | 0 | 201110 |  | 2012-04-22 00:00:00 | 671.04
1 | 1031 | MARTYN | Jones | 125 | 2011-12-18 00:00:00 | 0 | 201110 |  | 1031 | 0
1 | 1031 | MARTYN | Jones | 125 | 2011-12-25 00:00:00 | 0 | 201110 |  | 2011-12-11 00:00:00 | 0
1 | 1031 | MARTYN | Jones | 125 | 2012-01-01 00:00:00 | 0 | 201110 |  | 2011-12-18 00:00:00 | 0
1 | 1031 | MARTYN | Jones | 125 | 2012-01-08 00:00:00 | 0 | 201110 |  | 2011-12-25 00:00:00 | 0
1 | 1031 | MARTYN | Jones | 125 | 2012-01-15 00:00:00 | 0 | 201110 |  | 2012-01-01 00:00:00 | 0
1 | 1031 | MARTYN | Jones | 125 | 2012-01-22 00:00:00 | 0 | 201110 |  | 2012-01-08 00:00:00 | 0
1 | 1031 | MARTYN | Jones | 125 | 2012-01-29 00:00:00 | 0 | 201110 |  | 2012-01-15 00:00:00 | 0
1 | 1031 | MARTYN | Jones | 125 | 2012-02-19 00:00:00 | 0 | 201111 |  | 2012-01-22 00:00:00 | 0
1 | 1031 | MARTYN | Jones | 125 | 2012-02-26 00:00:00 | 0 | 201111 |  | 2012-01-29 00:00:00 | 0
1 | 1031 | MARTYN | Jones | 125 | 2012-03-04 00:00:00 | 0 | 201112 |  | 2012-02-19 00:00:00 | 0
1 | 1152 | STEVE | [NAME] | 425 | 2012-01-15 00:00:00 | 0 | 201110 |  | 2012-02-26 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2011-11-13 00:00:00 | 0 | 201111 |  | 2012-03-04 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2011-11-20 00:00:00 | 0 | 201111 |  | 1152 | 0
1 | 1243 | KLAUS | Smith | 124 | 2011-11-27 00:00:00 | 0 | 201111 |  | 2012-01-15 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2011-12-04 00:00:00 | 0 | 201111 |  | 1243 | 0
1 | 1243 | KLAUS | Smith | 124 | 2011-12-11 00:00:00 | 0 | 201111 |  | 2011-11-13 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2011-12-18 00:00:00 | 0 | 201111 |  | 2011-11-20 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2011-12-25 00:00:00 | 0 | 201111 |  | 2011-11-27 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2012-01-08 00:00:00 | 312.18 | 201110 |  | 2011-12-04 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2012-01-08 00:00:00 | -312.18 | 201111 |  | 2011-12-11 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2012-01-15 00:00:00 | 141.9 | 201110 |  | 2011-12-18 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2012-01-15 00:00:00 | -141.9 | 201111 |  | 2011-12-25 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2012-01-22 00:00:00 | 198.66 | 201110 |  | 2012-01-08 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2012-01-22 00:00:00 | -198.66 | 201111 |  | 2012-01-15 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2012-01-29 00:00:00 | 141.9 | 201110 |  | 2012-01-22 00:00:00 | 0
1 | 1243 | KLAUS | Smith | 124 | 2012-01-29 00:00:00 | -141.9 | 201111 |  | 2012-01-29 00:00:00 | 0
 |  |  |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  |  |  | Grand Total | 7605.12