Spreadsheet: 240885d1370442877-summarising-forecast-data-pt-calculaated-item
Sheet: Sheet1

Quote No. | Date | Account | Name | [NAME] | Quantity | Price | Product | Description 2
443523 | 2013-04-02 00:00:00 | 15619 | SOFTCELL Limited | COMBAT STRESS | 300 | 6.01 | KL4863UATFC | [NAME] for Business - Select UK Ed. 250-499 Node 1 year [NAME]
443523 | 2013-04-02 00:00:00 | 15619 | SOFTCELL Limited | COMBAT STRESS | 300 | 9.61 | KL4863UATDC | [NAME] for Business - Select UK Ed. 250-499 Node 2 year [NAME] |  |  |  |  |  |  |  |  | I think this pivot table is what you want??
443523 | 2013-04-02 00:00:00 | 15619 | SOFTCELL Limited | COMBAT STRESS | 300 | 13.51 | KL4863UATTC | [NAME] for Business - Select UK Ed. 250-499 Node 3 year [NAME]
443523 | 2013-04-02 00:00:00 | 15619 | SOFTCELL Limited | COMBAT STRESS | 300 | 4.89 | KL4863UATFC/14 | [NAME] for Business - Select UK Ed. 250-499 Node 1 year [NAME] |  |  |  |  |  |  |  |  | Row Labels | Sum of Quantity | Sum of Total Values
443523 | 2013-04-02 00:00:00 | 15619 | SOFTCELL Limited | COMBAT STRESS | 300 | 7.81 | KL4863UATDC/14 | [NAME] for Business - Select UK Ed. 250-499 Node 2 year [NAME] |  |  |  |  |  |  |  |  | 443523 | 1800 | 95076
443523 | 2013-04-02 00:00:00 | 15619 | SOFTCELL Limited | COMBAT STRESS | 300 | 10.99 | KL4863UATTC/14 | [NAME] for Business - Select UK Ed. 250-499 Node 3 year [NAME] |  |  |  |  |  |  |  |  | 443527 | 150 | 24484.5
443527 | 2013-04-02 00:00:00 | 56418 | Smarter Ltd | KASP GREENBANK SELECT+MAIL | 25 | 79.57 | KL4867UAPTS | [NAME] for Business - Advanced UK Ed. 25-49 Node 3 year [NAME] |  |  |  |  |  |  |  |  | 443536 | 57 | 6752.22
443527 | 2013-04-02 00:00:00 | 56418 | Smarter Ltd | KASP GREENBANK SELECT+MAIL | 25 | 8.85 | KL4313UAPTH | Kaspersky Security for Mail Server UK Edition. 25-49 User 3 year Add-on License |  |  |  |  |  |  |  |  | 443546 | 3 | 360
443527 | 2013-04-02 00:00:00 | 56418 | Smarter Ltd | KASP GREENBANK SELECT+MAIL | 25 | 42.94 | KL4863UAPTS | [NAME] for Business - Select UK Ed. 25-49 Node 3 year [NAME] |  |  |  |  |  |  |  |  | 443573 | 105 | 6584.550000000001
443527 | 2013-04-02 00:00:00 | 56418 | Smarter Ltd | KASP GREENBANK SELECT+MAIL | 25 | 8.85 | KL4313UAPTH | Kaspersky Security for Mail Server UK Edition. 25-49 User 3 year Add-on License |  |  |  |  |  |  |  |  | 443577 | 75 | 813
443527 | 2013-04-02 00:00:00 | 56418 | Smarter Ltd | KASP GREENBANK SELECT+MAIL | 25 | 19.09 | KL4863UAPFS | [NAME] for Business - Select UK Ed. 25-49 Node 1 year [NAME] |  |  |  |  |  |  |  |  | 443586 | 25 | 301.75
443527 | 2013-04-02 00:00:00 | 56418 | Smarter Ltd | KASP GREENBANK SELECT+MAIL | 25 | 3.93 | KL4313UAPFH | Kaspersky Security for Mail Server UK Edition. 25-49 User 1 year Add-on License |  |  |  |  |  |  |  |  | 443587 | 10 | 166.6
443536 | 2013-04-02 00:00:00 | 56380 | Brookes Systems Ltd | KASP NEW / INTERNAL USE | 19 | 24.42 | [NAME] | [NAME] for Business - Select UK Ed. 15-19 Node 1 year [NAME] |  |  |  |  |  |  |  |  | Grand Total | 2225 | 1238857.75
443536 | 2013-04-02 00:00:00 | 56380 | Brookes Systems Ltd | KASP NEW / INTERNAL USE | 19 | 39.08 | KL4863UAMDS | [NAME] for Business - Select UK Ed. 15-19 Node 2 year [NAME]
443536 | 2013-04-02 00:00:00 | 56380 | Brookes Systems Ltd | KASP NEW / INTERNAL USE | 19 | 54.96 | KL4863UAMTS | [NAME] for Business - Select UK Ed. 15-19 Node 3 year [NAME]
443546 | 2013-04-02 00:00:00 | 53595 | Onea Ltd | KASP REN DIGILEAFLET | 3 | 120 | KL2528UCEFS | 5 Users & 1 File Server 1 Year License Pack
443573 | 2013-04-02 00:00:00 | 52764 | Care Solutions | KASP REN GEGA LOTZ LTD | 35 | 12.93 | KL4863UAPFR | [NAME] for Business - Select UK Ed. 25-49 Node 1 year [NAME]
443573 | 2013-04-02 00:00:00 | 52764 | Care Solutions | KASP REN GEGA LOTZ LTD | 35 | 20.69 | KL4863UAPDR | [NAME] for Business - Select UK Ed. 25-49 Node 2 year [NAME]
443573 | 2013-04-02 00:00:00 | 52764 | Care Solutions | KASP REN GEGA LOTZ LTD | 35 | 29.09 | KL4863UAPTR | [NAME] for Business - Select UK Ed. 25-49 Node 3 year [NAME]
443577 | 2013-04-02 00:00:00 | C60000 | Lan Ltd | KASP REN DENTONS PENSION | 75 | 10.84 | KL4863UAQFR/10 | [NAME] for Business - Select UK Ed. 50-99 Node 1 year [NAME]
443586 | 2013-04-02 00:00:00 | C60000 | Lan Ltd | KASP REN LE MAITRE LIMITED | 25 | 12.07 | KL4863UAPFR/10 | [NAME] for Business - Select UK Ed. 25-49 Node 1 year [NAME]
443587 | 2013-04-02 00:00:00 | C60000 | Lan Ltd | KASP REN MCPHERSONS ACCOUNTANT | 10 | 16.66 | KL4863UAKFR/10 | [NAME] for Business - Select UK Ed. 10-14 Node 1 year [NAME]