Spreadsheet: 145528d1331639898-grouping-data-in-pivot-tables-mar
Sheet: Sheet1

Client | Company | Revenue(£) | Supplier | Margin(£) | % Margin
A00029 | A4E Ltd. (Parent) (F2F) Outside London | 1580 | 1264 | 316 | 0.2
A00253 | TAUNTON BRENDON HOUSE JCP (DWP) | 1675 | 1340 | 335 | 0.2
A00308 | Staffordshire and West Midlands Probation Trust - BSL | 3514 | 2811.2 | 702.8000000000002 | 0.2
DWPEM36647 | [NAME] (DWP) | 1997 | 1597.6 | 399.4000000000001 | 0.2
IWS54 | ROYAL FREE HAMPSTEAD NHS TRUST | 3717 | 2973.6 | 743.4000000000001 | 0.2
LM32036 | HMP Gartree | 2982 | 2385.6 | 596.4000000000001 | 0.2
LM57388 | Slough Jobcentre Plus (DWP) | 3996 | 3196.8 | 799.1999999999998 | 0.2
LM58071 | High Wycombe Pension Service (DWP) | 2979 | 2383.2 | 595.8000000000002 | 0.2000000000000001
LM65156 | York Hospitals NHS Trust | 4735 | 3788 | 947 | 0.2
LM67857 | [NAME] (DWP) | 1449 | 1159.2 | 289.8 | 0.2
LM70976 | Places for People - Bristol | 1415 | 1132 | 283 | 0.2
LM73676 | South West Essex PCT (HQ) (NHS) | 2007 | 1605.6 | 401.4000000000001 | 0.2
S00100686 | Great Ormond Street Hospital for Children NHS Trust - F2F. | 1782 | 1425.6 | 356.4000000000001 | 0.2
S00100708 | Newcastle Upon Tyne NHS Foundation Trust -Plastics | 2966 | 2372.8 | 593.1999999999998 | 0.1999999999999999
S00101179 | [NAME] (DWP) | 4259 | 3407.2 | 851.8000000000002 | 0.2
S00101189 | Camberwell Green Jobcentre Plus (DWP) | 1036 | 828.8 | 207.2 | 0.2
S76918 | [NAME] (DWP) | 1935 | 1548 | 387 | 0.2
S79329 | Northampton General Hospital - Clinical Oncology (NHS) | 2288 | 1830.4 | 457.5999999999999 | 0.2
S79331 | Northampton General Hospital - Head and Neck & Ophthalmology (NHS) | 4635 | 3708 | 927 | 0.2
S79333 | Northampton General Hospital - General Surgery (NHS) | 1275 | 1020 | 255 | 0.2
S79334 | Northampton General Hospital - Medicine A&E (NHS) | 1844 | 1475.2 | 368.8 | 0.2
S79336 | Northampton General Hospital - Trauma and Orthopaedics (NHS) | 3656 | 2924.8 | 731.1999999999998 | 0.2
S79418 | [NAME] | 4950 | 3960 | 990 | 0.2
S81622 | [NAME] Spring Pension Service (DWP) | 3762 | 3009.6 | 752.4000000000001 | 0.2
S83245 | LB [NAME] Community Services | 4751 | 3800.8 | 950.1999999999998 | 0.2
S83258 | [NAME] | 3175 | 2540 | 635 | 0.2
S83616 | Ealing Hospital NHS Trust | 1071 | 856.8 | 214.2 | 0.2
S85288 | [NAME] (DWP) | 4721 | 3776.8 | 944.1999999999998 | 0.2
S86019 | [NAME] | 1460 | 1168 | 292 | 0.2
S87380 | A4E | 3120 | 2496 | 624 | 0.2
S88961 | [NAME] (DWP) | 2222 | 1777.6 | 444.4000000000001 | 0.2
S89520 | Swindon Local Pension Service (DWP) | 3535 | 2828 | 707 | 0.2
S90234 | Nottingham University Hospitals NHS Trust - Acute Medicine | 4397 | 3517.6 | 879.4000000000001 | 0.2
S90240 | Nottingham University Hospitals NHS Trust - Family Health | 1279 | 1023.2 | 255.8 | 0.2
S90262 | Nottingham University Hospitals NHS Trust - Diabetes, Infectious Diseases, Renal and Cardiovascular | 2467 | 1973.6 | 493.4000000000001 | 0.2
S90263 | Nottingham University Hospitals NHS Trust - Head & Neck | 1723 | 1378.4 | 344.5999999999999 | 0.2
S90264 | Nottingham University Hospitals NHS Trust - Musculoskeletal & Neurosciences | 3762 | 3009.6 | 752.4000000000001 | 0.2
S90293 | Home Group - Stonham | 1296 | 1036.8 | 259.2 | 0.2
S90371 | East Kent Hospitals NHS Trust | 4018 | 3214.4 | 803.5999999999999 | 0.2
S90386 | Scarborough & North East Yorkshire Healthcare NHS Trust | 4494 | 3595.2 | 898.8000000000002 | 0.2
S90514 | [NAME] and [NAME] | 2714 | 2171.2 | 542.8000000000002 | 0.2000000000000001
S90655 | Calderdale and Huddersfield NHS Foundation Trust | 1988 | 1590.4 | 397.5999999999999 | 0.2
S91209 | Barnsley PCT | 1139 | 911.2 | 227.8 | 0.2
S91259 | Cardiff Local Pension Service (DWP) | 2362 | 1889.6 | 472.4000000000001 | 0.2
S91383 | Royal Berkshire Hospital NHS Foundation Trust - Maternity Division | 2374 | 1899.2 | 474.8 | 0.2
S91569 | Newcastle Upon Tyne NHS Foundation Trust - Cancer/Haematology | 2468 | 1974.4 | 493.5999999999999 | 0.2
S91573 | Newcastle Upon Tyne NHS Foundation Trust - ENT | 2403 | 1922.4 | 480.5999999999999 | 0.2
S91578 | Newcastle Upon Tyne NHS Foundation Trust - Neurosciences | 4725 | 3780 | 945 | 0.2
S91580 | Newcastle Upon Tyne NHS Foundation Trust -Ophthalmology | 2628 | 2102.4 | 525.5999999999999 | 0.2
S91583 | Newcastle Upon Tyne NHS Foundation Trust - Renal Services | 3531 | 2824.8 | 706.1999999999998 | 0.2
S91588 | Newcastle Upon Tyne NHS Foundation Trust -Rehabilitation | 2318 | 1854.4 | 463.5999999999999 | 0.2
S91589 | Newcastle Upon Tyne NHS Foundation Trust - Main Out-Patients | 2651 | 2120.8 | 530.1999999999998 | 0.1999999999999999
S91622 | Newcastle Upon Tyne NHS Foundation Trust - Dermatology | 4218 | 3374.4 | 843.5999999999999 | 0.2
S91983 | The Rotherham NHS Foundation Trust - Obstetrics & Gynaecology | 4011 | 3208.8 | 802.1999999999998 | 0.2
S92003 | The Rotherham NHS Foundation Trust - Urology | 2277 | 1821.6 | 455.4000000000001 | 0.2
S92122 | The Rotherham NHS Foundation Trust - Radiology | 3972 | 3177.6 | 794.4000000000001 | 0.2
S92125 | The Rotherham NHS Foundation Trust - Main Outpatient Department | 2141 | 1712.8 | 428.2 | 0.2
S92239 | Barnsley Hospital NHS Foundation Trust | 4902 | 3921.6 | 980.4000000000001 | 0.2
S92590 | [NAME] and [NAME] | 2880 | 2304 | 576 | 0.2
S92691 | MoJ Shared Services | 2206 | 1764.8 | 441.2 | 0.2
S93050 | Yeovil District Hospital NHS Foundation Trust | 1290 | 1032 | 258 | 0.2
S93597 | South London Healthcare NHS Trust | 2458 | 1966.4 | 491.5999999999999 | 0.2
S93601 | Royal Wolverhampton Hospitals NHS Trust | 4585 | 3668 | 917 | 0.2
[NAME] | Warrington and [NAME], Childrens and Support Services | 2167 | 1733.6 | 433.4000000000001 | 0.2
S94031 | Warrington and [NAME] Care | 3617 | 2893.6 | 723.4000000000001 | 0.2
S94032 | Warrington and [NAME] | 2102 | 1681.6 | 420.4000000000001 | 0.2
S94101 | The Royal Marsden NHS Foundation Trust - NHS | 4145 | 3316 | 829 | 0.2
S94607 | West Middlesex University Hospital NHS Trust | 4847 | 3877.6 | 969.4000000000001 | 0.2
S94635 | Moorfields Eye Hospital NHS Foundation Trust | 1215 | 972 | 243 | 0.2
S95067 | North Middlesex University Hospital Trust- Accute and General Medicine | 4051 | 3240.8 | 810.1999999999998 | 0.2
S95068 | North Middlesex University Hospital Trust- Specialist Medicine and Support Services | 1536 | 1228.8 | 307.2 | 0.2
S95070 | North Middlesex University Hospital Trust- Women's and Childrens | 2111 | 1688.8 | 422.2 | 0.2
S95731 | [NAME] (DWP) | 3781 | 3024.8 | 756.1999999999998 | 0.2
S96255 | [NAME] | 1352 | 1081.6 | 270.4000000000001 | 0.2000000000000001
S96871 | LB Camden - Central Services_Corporate Communication team (F2F) | 2294 | 1835.2 | 458.8 | 0.2
S96877 | LB Camden - CSF_Euston Children's Centre (F2F) | 1106 | 884.8 | 221.2 | 0.2
S96878 | LB Camden - HASC_Occupational Therapy (F2F) | 3180 | 2544 | 636 | 0.2
S96889 | LB Camden - Culture and Environment_Community Safety (F2F) | 2785 | 2228 | 557 | 0.2
S96891 | LB Camden - Adult Social Care- reviews team (F2F) | 1649 | 1319.2 | 329.8 | 0.2
S96897 | LB Camden - CSF_KTW (F2F) | 4564 | 3651.2 | 912.8000000000002 | 0.2
S96900 | LB Camden - HASC_Business Support Team (F2F) | 4276 | 3420.8 | 855.1999999999998 | 0.2
S97071 | [NAME] | 2748 | 2198.4 | 549.5999999999999 | 0.2
S97091 | LB Camden- HASC_engagement and research team (F2F) | 1714 | 1371.2 | 342.8 | 0.2
S97094 | [NAME] homes (F2F) | 3029 | 2423.2 | 605.8000000000002 | 0.2000000000000001
S97346 | LB Camden - CSF_ Harmood Children’s Centre (F2F) | 2173 | 1738.4 | 434.5999999999999 | 0.2
A00029 | A4E Ltd. (Parent) (F2F) Outside London | 1281 | 1024.8 | 256.2 | 0.2
A00253 | TAUNTON BRENDON HOUSE JCP (DWP) | 1885 | 1508 | 377 | 0.2
A00308 | Staffordshire and West Midlands Probation Trust - BSL | 1508 | 1206.4 | 301.5999999999999 | 0.1999999999999999
DWPEM36647 | [NAME] (DWP) | 4341 | 3472.8 | 868.1999999999998 | 0.2
IWS54 | ROYAL FREE HAMPSTEAD NHS TRUST | 2796 | 2236.8 | 559.1999999999998 | 0.1999999999999999
LM32036 | HMP Gartree | 3619 | 2895.2 | 723.8000000000002 | 0.2
LM57388 | Slough Jobcentre Plus (DWP) | 4898 | 3918.4 | 979.5999999999999 | 0.2
LM58071 | High Wycombe Pension Service (DWP) | 4185 | 3348 | 837 | 0.2
LM65156 | York Hospitals NHS Trust | 3724 | 2979.2 | 744.8000000000002 | 0.2
LM67857 | [NAME] (DWP) | 2292 | 1833.6 | 458.4000000000001 | 0.2
LM70976 | Places for People - Bristol | 2436 | 1948.8 | 487.2 | 0.2
LM73676 | South West Essex PCT (HQ) (NHS) | 1272 | 1017.6 | 254.4 | 0.2
S00100686 | Great Ormond Street Hospital for Children NHS Trust - F2F. | 2772 | 2217.6 | 554.4000000000001 | 0.2
S00100708 | Newcastle Upon Tyne NHS Foundation Trust -Plastics | 1208 | 966.4 | 241.6 | 0.2
S00101179 | [NAME] (DWP) | 4829 | 3863.2 | 965.8000000000002 | 0.2
S00101189 | Camberwell Green Jobcentre Plus (DWP) | 4719 | 3775.2 | 943.8000000000002 | 0.2
S76918 | [NAME] (DWP) | 4157 | 3325.6 | 831.4000000000001 | 0.2
S79329 | Northampton General Hospital - Clinical Oncology (NHS) | 2155 | 1724 | 431 | 0.2
S79331 | Northampton General Hospital - Head and Neck & Ophthalmology (NHS) | 4207 | 3365.6 | 841.4000000000001 | 0.2
S79333 | Northampton General Hospital - General Surgery (NHS) | 1666 | 1332.8 | 333.2 | 0.2
S79334 | Northampton General Hospital - Medicine A&E (NHS) | 4244 | 3395.2 | 848.8000000000002 | 0.2
S79336 | Northampton General Hospital - Trauma and Orthopaedics (NHS) | 2344 | 1875.2 | 468.8 | 0.2
S79418 | [NAME] | 4042 | 3233.6 | 808.4000000000001 | 0.2
S81622 | [NAME] Spring Pension Service (DWP) | 1775 | 1420 | 355 | 0.2
S83245 | LB [NAME] Community Services | 3012 | 2409.6 | 602.4000000000001 | 0.2
S83258 | [NAME] | 4840 | 3872 | 968 | 0.2
S83616 | Ealing Hospital NHS Trust | 1401 | 1120.8 | 280.2 | 0.2
S85288 | [NAME] (DWP) | 3547 | 2837.6 | 709.4000000000001 | 0.2
S86019 | [NAME] | 4347 | 3477.6 | 869.4000000000001 | 0.2
S87380 | A4E | 2369 | 1895.2 | 473.8 | 0.2
S88961 | [NAME] (DWP) | 4156 | 3324.8 | 831.1999999999998 | 0.2
S89520 | Swindon Local Pension Service (DWP) | 3182 | 2545.6 | 636.4000000000001 | 0.2
S90234 | Nottingham University Hospitals NHS Trust - Acute Medicine | 2799 | 2239.2 | 559.8000000000002 | 0.2000000000000001
S90240 | Nottingham University Hospitals NHS Trust - Family Health | 2976 | 2380.8 | 595.1999999999998 | 0.1999999999999999
S90262 | Nottingham University Hospitals NHS Trust - Diabetes, Infectious Diseases, Renal and Cardiovascular | 4024 | 3219.2 | 804.8000000000002 | 0.2
S90263 | Nottingham University Hospitals NHS Trust - Head & Neck | 2851 | 2280.8 | 570.1999999999998 | 0.1999999999999999
S90264 | Nottingham University Hospitals NHS Trust - Musculoskeletal & Neurosciences | 2427 | 1941.6 | 485.4000000000001 | 0.2
S90293 | Home Group - Stonham | 3166 | 2532.8 | 633.1999999999998 | 0.2
S90371 | East Kent Hospitals NHS Trust | 4439 | 3551.2 | 887.8000000000002 | 0.2
S90386 | Scarborough & North East Yorkshire Healthcare NHS Trust | 3283 | 2626.4 | 656.5999999999999 | 0.2
S90514 | [NAME] and [NAME] | 4499 | 3599.2 | 899.8000000000002 | 0.2
S90655 | Calderdale and Huddersfield NHS Foundation Trust | 1192 | 953.6 | 238.4 | 0.2
S91209 | Barnsley PCT | 2491 | 1992.8 | 498.2 | 0.2
S91259 | Cardiff Local Pension Service (DWP) | 1335 | 1068 | 267 | 0.2
S91383 | Royal Berkshire Hospital NHS Foundation Trust - Maternity Division | 2555 | 2044 | 511 | 0.2
S91569 | Newcastle Upon Tyne NHS Foundation Trust - Cancer/Haematology | 2803 | 2242.4 | 560.5999999999999 | 0.2
S91573 | Newcastle Upon Tyne NHS Foundation Trust - ENT | 4109 | 3287.2 | 821.8000000000002 | 0.2
S91578 | Newcastle Upon Tyne NHS Foundation Trust - Neurosciences | 4424 | 3539.2 | 884.8000000000002 | 0.2
S91580 | Newcastle Upon Tyne NHS Foundation Trust -Ophthalmology | 2892 | 2313.6 | 578.4000000000001 | 0.2
S91583 | Newcastle Upon Tyne NHS Foundation Trust - Renal Services | 1978 | 1582.4 | 395.5999999999999 | 0.2
S91588 | Newcastle Upon Tyne NHS Foundation Trust -Rehabilitation | 4875 | 3900 | 975 | 0.2
S91589 | Newcastle Upon Tyne NHS Foundation Trust - Main Out-Patients | 2417 | 1933.6 | 483.4000000000001 | 0.2
S91622 | Newcastle Upon Tyne NHS Foundation Trust - Dermatology | 1468 | 1174.4 | 293.5999999999999 | 0.1999999999999999
S91983 | The Rotherham NHS Foundation Trust - Obstetrics & Gynaecology | 2563 | 2050.4 | 512.5999999999999 | 0.2
S92003 | The Rotherham NHS Foundation Trust - Urology | 2601 | 2080.8 | 520.1999999999998 | 0.1999999999999999
S92122 | The Rotherham NHS Foundation Trust - Radiology | 2877 | 2301.6 | 575.4000000000001 | 0.2
S92125 | The Rotherham NHS Foundation Trust - Main Outpatient Department | 1983 | 1586.4 | 396.5999999999999 | 0.2
S92239 | Barnsley Hospital NHS Foundation Trust | 1846 | 1476.8 | 369.2 | 0.2
S92590 | [NAME] and [NAME] | 3119 | 2495.2 | 623.8000000000002 | 0.2000000000000001
S92691 | MoJ Shared Services | 3250 | 2600 | 650 | 0.2
S93050 | Yeovil District Hospital NHS Foundation Trust | 2507 | 2005.6 | 501.4000000000001 | 0.2
S93597 | South London Healthcare NHS Trust | 2137 | 1709.6 | 427.4000000000001 | 0.2
S93601 | Royal Wolverhampton Hospitals NHS Trust | 4669 | 3735.2 | 933.8000000000002 | 0.2
[NAME] | Warrington and [NAME], Childrens and Support Services | 1995 | 1596 | 399 | 0.2
S94031 | Warrington and [NAME] Care | 2698 | 2158.4 | 539.5999999999999 | 0.2
S94032 | Warrington and [NAME] | 4789 | 3831.2 | 957.8000000000002 | 0.2
S94101 | The Royal Marsden NHS Foundation Trust - NHS | 1457 | 1165.6 | 291.4000000000001 | 0.2000000000000001
S94607 | West Middlesex University Hospital NHS Trust | 2283 | 1826.4 | 456.5999999999999 | 0.2
S94635 | Moorfields Eye Hospital NHS Foundation Trust | 2690 | 2152 | 538 | 0.2
S95067 | North Middlesex University Hospital Trust- Accute and General Medicine | 2304 | 1843.2 | 460.8 | 0.2
S95068 | North Middlesex University Hospital Trust- Specialist Medicine and Support Services | 3520 | 2816 | 704 | 0.2
S95070 | North Middlesex University Hospital Trust- Women's and Childrens | 1136 | 908.8 | 227.2 | 0.2
S95731 | [NAME] (DWP) | 3451 | 2760.8 | 690.1999999999998 | 0.2
S96255 | [NAME] | 4308 | 3446.4 | 861.5999999999999 | 0.2
S96871 | LB Camden - Central Services_Corporate Communication team (F2F) | 2788 | 2230.4 | 557.5999999999999 | 0.2
S96877 | LB Camden - CSF_Euston Children's Centre (F2F) | 4113 | 3290.4 | 822.5999999999999 | 0.2
S96878 | LB Camden - HASC_Occupational Therapy (F2F) | 3891 | 3112.8 | 778.1999999999998 | 0.2
S96889 | LB Camden - Culture and Environment_Community Safety (F2F) | 3226 | 2580.8 | 645.1999999999998 | 0.2
S96891 | LB Camden - Adult Social Care- reviews team (F2F) | 3039 | 2431.2 | 607.8000000000002 | 0.2000000000000001
S96897 | LB Camden - CSF_KTW (F2F) | 4150 | 3320 | 830 | 0.2
S96900 | LB Camden - HASC_Business Support Team (F2F) | 2332 | 1865.6 | 466.4000000000001 | 0.2
S97071 | [NAME] | 2804 | 2243.2 | 560.8000000000002 | 0.2000000000000001
S97091 | LB Camden- HASC_engagement and research team (F2F) | 4287 | 3429.6 | 857.4000000000001 | 0.2
S97094 | [NAME] homes (F2F) | 1309 | 1047.2 | 261.8 | 0.2
S97346 | LB Camden - CSF_ Harmood Children’s Centre (F2F) | 3739 | 2991.2 | 747.8000000000002 | 0.2