Spreadsheet: 128489d1321007226-pivot-table-auto-referesh-paul-master-forecast-model-pivot-refresh
Sheet: Customer

 | Select a Product Group |  |  |  | Cutomer Number
 | AND / OR |  |  |  | 2
 | Georgian
 | AND / OR
 | Spacer
 | AND / OR
 | Textured
 | [NAME]
 | Product Group | [NAME] | Spacer | Textured | Georgian | Price | Volume | Revenue |  |  | Product Group | Volume |  | Sum of Volume
 | EnergiKare | Annealed | Aluminium | No | No | 25 | 11 | 59 |  |  | EnergiKare | 1574 |  | Product Group | Spacer | Total
 | EnergiKare | Annealed | Super | No | No | 24 | 27 | 56 |  |  | [NAME] | 1605 |  | [NAME] | Aluminium | 0
 | EnergiKare | Annealed | Swiss | No | No | 29 | 65 | 48 |  |  | Triple Glazed | 1562 |  |  | Super | 0
 | EnergiKare | Annealed | TGI | No | No | 79 | 65 | 69 |  |  | Laminated | 869 |  |  | Swiss | 0
 | EnergiKare | Toughened | Aluminium | No | No | 6 | 39 | 51 |  |  | Other | 1439 |  |  | TGI | 0
 | EnergiKare | Toughened | Super | No | No | 94 | 19 | 45 |  |  | ST | 97 |  | Conservatory Roof Total |  | 0
 | EnergiKare | Toughened | Swiss | No | No | 87 | 75 | 59 |  |  | [NAME] | 134 |  | EnergiKare | Aluminium | 48.35
 | EnergiKare | Toughened | TGI | No | No | 25 | 27 | 73 |  |  |  |  |  |  | Super | 0
 | [NAME] | Annealed | Aluminium | No | No | 3 | 59 | 65 |  |  |  |  |  |  | Swiss | 0
 | [NAME] | Annealed | Super | No | No | 2 | 94 | 40 |  |  |  |  |  |  | TGI | 0
 | [NAME] | Annealed | Swiss | No | No | 52 | 13 | 57 |  |  |  |  |  | EnergiKare Total |  | 48.35
 | [NAME] | Annealed | TGI | No | No | 11 | 37 | 64 |  |  |  |  |  | Laminated | Aluminium | 2.38
 | [NAME] | Toughened | Aluminium | No | No | 28 | 28 | 75 |  |  |  |  |  |  | Super | 0
 | [NAME] | Toughened | Super | No | No | 5 | 33 | 97 |  |  |  |  |  |  | Swiss | 0
 | [NAME] | Toughened | Swiss | No | No | 52 | 77 | 27 |  |  |  |  |  |  | TGI | 0
 | [NAME] | Toughened | TGI | No | No | 69 | 62 | 95 |  |  |  |  |  | Laminated Total |  | 2.38
 | Triple Glazed | Annealed | Aluminium | No | No | 2 | 45 | 100 |  |  |  |  |  | Other | Aluminium | 41.01
 | Triple Glazed | Annealed | Super | No | No | 91 | 19 | 61 |  |  |  |  |  |  | Super | 0
 | Triple Glazed | Annealed | Swiss | No | No | 86 | 96 | 83 |  |  |  |  |  |  | Swiss | 0
 | Triple Glazed | Annealed | TGI | No | No | 31 | 30 | 37 |  |  |  |  |  |  | TGI | 0
 | Triple Glazed | Toughened | Aluminium | No | No | 12 | 79 | 97 |  |  |  |  |  | Other Total |  | 41.01
 | Triple Glazed | Toughened | Super | No | No | 43 | 80 | 45 |  |  |  |  |  | [NAME] | Aluminium | 0
 | Triple Glazed | Toughened | Swiss | No | No | 5 | 37 | 94 |  |  |  |  |  |  | Super | 0
 | Triple Glazed | Toughened | TGI | No | No | 42 | 85 | 91 |  |  |  |  |  |  | Swiss | 0
 | Laminated | Annealed | Aluminium | No | No | 19 | 99 | 37 |  |  |  |  |  |  | TGI | 0
 | Laminated | Annealed | Super | No | No | 90 | 77 | 19 |  |  |  |  |  | [NAME] |  | 0
 | Laminated | Annealed | Swiss | No | No | 89 | 72 | 2 |  |  |  |  |  | ST | No Spacer | 0
 | Laminated | Annealed | TGI | No | No | 31 | 68 | 63 |  |  |  |  |  | ST Total |  | 0
 | EnergiKare | Annealed | Aluminium | Yes | No | 33 | 47 | 69 |  |  |  |  |  | Triple Glazed | Aluminium | 0
 | EnergiKare | Annealed | Super | Yes | No | 4 | 71 | 61 |  |  |  |  |  |  | Super | 0
 | EnergiKare | Annealed | Swiss | Yes | No | 56 | 22 | 7 |  |  |  |  |  |  | Swiss | 0
 | EnergiKare | Annealed | TGI | Yes | No | 73 | 46 | 20 |  |  |  |  |  |  | TGI | 0
 | EnergiKare | Toughened | Aluminium | Yes | No | 19 | 88 | 61 |  |  |  |  |  | Triple Glazed Total |  | 0
 | EnergiKare | Toughened | Super | Yes | No | 69 | 60 | 4 |  |  |  |  |  | Grand Total |  | 91.74000000000001
 | EnergiKare | Toughened | Swiss | Yes | No | 73 | 18 | 36
 | EnergiKare | Toughened | TGI | Yes | No | 87 | 28 | 63
 | [NAME] | Annealed | Aluminium | Yes | No | 43 | 33 | 41
 | [NAME] | Annealed | Super | Yes | No | 71 | 100 | 39
 | [NAME] | Annealed | Swiss | Yes | No | 15 | 19 | 42
 | [NAME] | Annealed | TGI | Yes | No | 8 | 55 | 66
 | [NAME] | Toughened | Aluminium | Yes | No | 88 | 22 | 64
 | [NAME] | Toughened | Super | Yes | No | 92 | 90 | 62
 | [NAME] | Toughened | Swiss | Yes | No | 28 | 62 | 13
 | [NAME] | Toughened | TGI | Yes | No | 73 | 2 | 53
 | Triple Glazed | Annealed | Aluminium | Yes | No | 78 | 20 | 17
 | Triple Glazed | Annealed | Super | Yes | No | 36 | 14 | 24
 | Triple Glazed | Annealed | Swiss | Yes | No | 23 | 84 | 37
 | Triple Glazed | Annealed | TGI | Yes | No | 65 | 23 | 50
 | Triple Glazed | Toughened | Aluminium | Yes | No | 5 | 25 | 46
 | Triple Glazed | Toughened | Super | Yes | No | 55 | 99 | 79
 | Triple Glazed | Toughened | Swiss | Yes | No | 5 | 55 | 61
 | Triple Glazed | Toughened | TGI | Yes | No | 49 | 85 | 36
 | Laminated | Annealed | Aluminium | Yes | No | 9 | 65 | 14
 | Laminated | Annealed | Super | Yes | No | 58 | 90 | 72
 | Laminated | Annealed | Swiss | Yes | No | 29 | 31 | 56
 | Laminated | Annealed | TGI | Yes | No | 36 | 45 | 90
 | EnergiKare | Annealed | Aluminium | No | Yes | 90 | 74 | 2
 | EnergiKare | Annealed | Super | No | Yes | 24 | 13 | 1
 | EnergiKare | Annealed | Swiss | No | Yes | 21 | 46 | 61
 | EnergiKare | Annealed | TGI | No | Yes | 54 | 86 | 87
 | EnergiKare | Toughened | Aluminium | No | Yes | 59 | 47 | 10
 | EnergiKare | Toughened | Super | No | Yes | 64 | 53 | 98
 | EnergiKare | Toughened | Swiss | No | Yes | 83 | 83 | 61
 | EnergiKare | Toughened | TGI | No | Yes | 96 | 71 | 37
 | [NAME] | Annealed | Aluminium | No | Yes | 69 | 99 | 54
 | [NAME] | Annealed | Super | No | Yes | 27 | 1 | 24
 | [NAME] | Annealed | Swiss | No | Yes | 12 | 41 | 29
 | [NAME] | Annealed | TGI | No | Yes | 54 | 86 | 55
 | [NAME] | Toughened | Aluminium | No | Yes | 48 | 11 | 93
 | [NAME] | Toughened | Super | No | Yes | 50 | 36 | 69
 | [NAME] | Toughened | Swiss | No | Yes | 14 | 94 | 100
 | [NAME] | Toughened | TGI | No | Yes | 29 | 2 | 18
 | Triple Glazed | Annealed | Aluminium | No | Yes | 74 | 53 | 16
 | Triple Glazed | Annealed | Super | No | Yes | 56 | 99 | 59
 | Triple Glazed | Annealed | Swiss | No | Yes | 20 | 12 | 50
 | Triple Glazed | Annealed | TGI | No | Yes | 39 | 19 | 73
 | Triple Glazed | Toughened | Aluminium | No | Yes | 31 | 31 | 35
 | Triple Glazed | Toughened | Super | No | Yes | 10 | 25 | 79
 | Triple Glazed | Toughened | Swiss | No | Yes | 25 | 99 | 25
 | Triple Glazed | Toughened | TGI | No | Yes | 20 | 18 | 4
 | Laminated | Annealed | Aluminium | No | Yes | 29 | 43 | 88
 | Laminated | Annealed | Super | No | Yes | 79 | 12 | 67
 | Laminated | Annealed | Swiss | No | Yes | 98 | 76 | 60
 | Laminated | Annealed | TGI | No | Yes | 34 | 78 | 23
 | EnergiKare | Annealed | Aluminium | Yes | Yes | 54 | 96 | 51
 | EnergiKare | Annealed | Super | Yes | Yes | 41 | 5 | 31
 | EnergiKare | Annealed | Swiss | Yes | Yes | 96 | 72 | 70
 | EnergiKare | Annealed | TGI | Yes | Yes | 33 | 38 | 9
 | EnergiKare | Toughened | Aluminium | Yes | Yes | 37 | 83 | 90
 | EnergiKare | Toughened | Super | Yes | Yes | 23 | 33 | 7
 | EnergiKare | Toughened | Swiss | Yes | Yes | 24 | 2 | 66
 | EnergiKare | Toughened | TGI | Yes | Yes | 78 | 64 | 9
 | [NAME] | Annealed | Aluminium | Yes | Yes | 22 | 50 | 33
 | [NAME] | Annealed | Super | Yes | Yes | 28 | 83 | 55
 | [NAME] | Annealed | Swiss | Yes | Yes | 74 | 97 | 44
 | [NAME] | Annealed | TGI | Yes | Yes | 61 | 30 | 29
 | [NAME] | Toughened | Aluminium | Yes | Yes | 85 | 31 | 13
 | [NAME] | Toughened | Super | Yes | Yes | 47 | 96 | 2
 | [NAME] | Toughened | Swiss | Yes | Yes | 71 | 1 | 71
 | [NAME] | Toughened | TGI | Yes | Yes | 30 | 61 | 67
 | Triple Glazed | Annealed | Aluminium | Yes | Yes | 22 | 31 | 19
 | Triple Glazed | Annealed | Super | Yes | Yes | 89 | 74 | 23
 | Triple Glazed | Annealed | Swiss | Yes | Yes | 68 | 12 | 93
 | Triple Glazed | Annealed | TGI | Yes | Yes | 41 | 91 | 64
 | Triple Glazed | Toughened | Aluminium | Yes | Yes | 37 | 11 | 67
 | Triple Glazed | Toughened | Super | Yes | Yes | 22 | 73 | 27
 | Triple Glazed | Toughened | Swiss | Yes | Yes | 55 | 12 | 33
 | Triple Glazed | Toughened | TGI | Yes | Yes | 92 | 26 | 96
 | Laminated | Annealed | Aluminium | Yes | Yes | 15 | 58 | 19
 | Laminated | Annealed | Super | Yes | Yes | 64 | 23 | 77
 | Laminated | Annealed | Swiss | Yes | Yes | 16 | 4 | 71
 | Laminated | Annealed | TGI | Yes | Yes | 12 | 28 | 29
 | Other | Annealed | Aluminium | No | No | 66 | 70 | 91
 | Other | Annealed | Super | No | No | 4 | 21 | 96
 | Other | Annealed | Swiss | No | No | 72 | 66 | 15
 | Other | Annealed | TGI | No | No | 45 | 50 | 22
 | Other | Toughened | Aluminium | No | No | 70 | 88 | 63
 | Other | Toughened | Super | No | No | 79 | 24 | 69
 | Other | Toughened | Swiss | No | No | 21 | 39 | 63
 | Other | Toughened | TGI | No | No | 77 | 31 | 43
 | Other | Annealed | Aluminium | Yes | No | 100 | 54 | 57
 | Other | Annealed | Super | Yes | No | 62 | 47 | 79
 | Other | Annealed | Swiss | Yes | No | 84 | 5 | 29
 | Other | Annealed | TGI | Yes | No | 69 | 1 | 30
 | Other | Toughened | Aluminium | Yes | No | 23 | 30 | 14
 | Other | Toughened | Super | Yes | No | 24 | 24 | 36
 | Other | Toughened | Swiss | Yes | No | 46 | 32 | 96
 | Other | Toughened | TGI | Yes | No | 45 | 34 | 86
 | Other | Annealed | Aluminium | No | Yes | 66 | 45 | 27
 | Other | Annealed | Super | No | Yes | 98 | 28 | 41
 | Other | Annealed | Swiss | No | Yes | 51 | 18 | 2
 | Other | Annealed | TGI | No | Yes | 81 | 23 | 16
 | Other | Toughened | Aluminium | No | Yes | 23 | 74 | 36
 | Other | Toughened | Super | No | Yes | 94 | 59 | 59
 | Other | Toughened | Swiss | No | Yes | 62 | 8 | 51
 | Other | Toughened | TGI | No | Yes | 98 | 6 | 93
 | Other | Annealed | Aluminium | Yes | Yes | 59 | 6 | 65
 | Other | Annealed | Super | Yes | Yes | 77 | 99 | 34
 | Other | Annealed | Swiss | Yes | Yes | 64 | 40 | 93
 | Other | Annealed | TGI | Yes | Yes | 71 | 96 | 40
 | Other | Toughened | Aluminium | Yes | Yes | 56 | 86 | 97
 | Other | Toughened | Super | Yes | Yes | 76 | 88 | 10
 | Other | Toughened | Swiss | Yes | Yes | 36 | 73 | 88
 | Other | Toughened | TGI | Yes | Yes | 89 | 74 | 16
 | ST | Toughened | No Spacer | No | No | 50 | 97 | 17
 | [NAME] | Toughened | Aluminium | No | No | 64 | 27 | 40
 | [NAME] | Toughened | Super | No | No | 50 | 30 | 1
 | [NAME] | Toughened | Swiss | No | No | 63 | 61 | 51
 | [NAME] | Toughened | TGI | No | No | 69 | 16 | 8