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

 |  | Code | WK 01 | WK 02 | WK 03 | WK 04 | WK 05 | WK 06 |  |  | What I'm after is [NAME] that when created generates the same results as per the table opposite.     Basically the Pivot Table will calculate the sum of 'Hours' and Amounts' for each 'Code' week by week  (week 01 to week 06) based on the data in the 'Data' tab
 |  | 101 | 15 | 60 | 9.5 | 20.5 | 60 | 8
 |  |  | 1188.3 | 4753.2 | 752.59 | 1624.01 | 4753.2 | 633.76
 |  | 103 | 8.5 | 25.5 | 10 | 8.5 | 19.5 | 2.5
 |  |  | 673.37 | 2020.11 | 792.2 | 673.37 | 1544.79 | 198.05
 |  | 111 | 29.5 | 73.5 | 36 | 45.25 | 49.25 | 43.75
 |  |  | 2336.99 | 5822.67 | 2851.92 | 3584.705 | 3901.585 | 3465.875
 |  | 123 | 9.5 | 28 | 35 | 25.25 | 10.75 | 28.25
 |  |  | 752.59 | 2218.16 | 2772.7 | 2000.305 | 851.615 | 2237.965
 |  | 192 | 4.5 | 19.5 | 12.5 | 20.25 | 3.75 | 19.75
 |  |  | 356.49 | 1544.79 | 990.25 | 1604.205 | 297.075 | 1564.595
 |  | 222 | 15.5 | 16.5 | 39 | 10 | 12 | 16.5
 |  |  | 1227.91 | 1307.13 | 3089.58 | 792.2 | 950.64 | 1307.13
 |  | 248 | 6 | 10 | 7 | 6 | 8 | 10
 |  |  | 475.32 | 792.2 | 554.54 | 475.32 | 633.76 | 792.2
 |  | 333 | 11.5 | 24.5 | 20.5 | 27.25 | 12.25 | 24.75
 |  |  | 911.03 | 1940.89 | 1624.01 | 2158.745 | 970.445 | 1960.695
 |  | 444 | 8.5 | 25.5 | 10 | 8.5 | 19.5 | 2.5
 |  |  | 673.37 | 2020.11 | 792.2 | 673.37 | 1544.79 | 198.05
 |  | 456 | 25.25 | 29.5 | 19.25 | 15 | 42 | 11.5
 |  |  | 2000.305 | 2336.99 | 1524.985 | 1188.3 | 3327.24 | 911.03
 |  | 777 | 27.25 | 12 | 22.75 | 11.5 | 13 | 12
 |  |  | 2158.745 | 950.64 | 1802.255 | 911.03 | 1029.86 | 950.64
 |  | 999 | 10.5 | 8 | 16.5 | 5 | 5 | 8
 |  |  | 831.81 | 633.76 | 1307.13 | 396.1 | 396.1 | 633.76
 |  |  | Week | Data
 |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | Total Sum of Hrs | Total Sum of Amt
 |  | Code | Sum of Hrs | Sum of Amt | Sum of Hrs | Sum of Amt | Sum of Hrs | Sum of Amt | Sum of Hrs | Sum of Amt | Sum of Hrs | Sum of Amt | Sum of Hrs | Sum of Amt
 |  | 101 | 15 | 1188.3 | 60 | 4753.2 | 9.5 | 752.59 | 20.5 | 1624.01 | 60 | 4753.2 | 8 | 633.76 | 173 | 13705.06
 |  | 103 | 8.5 | 673.37 | 25.5 | 2020.11 | 10 | 792.2 | 8.5 | 673.37 | 19.5 | 1544.79 | 2.5 | 198.05 | 74.5 | 5901.89
 |  | 111 | 29.5 | 2336.99 | 73.5 | 5822.67 | 36 | 2851.92 | 45.25 | 3584.705 | 49.25 | 3901.585 | 43.75 | 3465.875 | 277.25 | 21963.745
 |  | 123 | 9.5 | 752.59 | 28 | 2218.16 | 35 | 2772.7 | 25.25 | 2000.305 | 10.75 | 851.615 | 28.25 | 2237.965 | 136.75 | 10833.335
 |  | 192 | 4.5 | 356.49 | 19.5 | 1544.79 | 12.5 | 990.25 | 20.25 | 1604.205 | 3.75 | 297.075 | 19.75 | 1564.595 | 80.25 | 6357.405
 |  | 222 | 15.5 | 1227.91 | 16.5 | 1307.13 | 39 | 3089.58 | 10 | 792.2 | 12 | 950.64 | 16.5 | 1307.13 | 109.5 | 8674.59
 |  | 248 | 6 | 475.32 | 10 | 792.2 | 7 | 554.54 | 6 | 475.32 | 8 | 633.76 | 10 | 792.2 | 47 | 3723.34
 |  | 333 | 11.5 | 911.03 | 24.5 | 1940.89 | 20.5 | 1624.01 | 27.25 | 2158.745 | 12.25 | 970.4449999999999 | 24.75 | 1960.695 | 120.75 | 9565.815
 |  | 444 | 8.5 | 673.37 | 25.5 | 2020.11 | 10 | 792.2 | 8.5 | 673.37 | 19.5 | 1544.79 | 2.5 | 198.05 | 74.5 | 5901.89
 |  | 456 | 25.25 | 2000.305 | 29.5 | 2336.99 | 19.25 | 1524.985 | 15 | 1188.3 | 42 | 3327.24 | 11.5 | 911.03 | 142.5 | 11288.85
 |  | 777 | 27.25 | 2158.745 | 12 | 950.64 | 22.75 | 1802.255 | 11.5 | 911.03 | 13 | 1029.86 | 12 | 950.64 | 98.5 | 7803.169999999999
 |  | 999 | 10.5 | 831.81 | 8 | 633.76 | 16.5 | 1307.13 | 5 | 396.1 | 5 | 396.1 | 8 | 633.76 | 53 | 4198.66
 |  | Grand Total | 171.5 | 13586.23 | 332.5 | 26340.65 | 238 | 18854.36 | 203 | 16081.66 | 255 | 20201.1 | 187.5 | 14853.75 | 1387.5 | 109917.75