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

Row Labels | Sum of Revenue(£) | Sum of Supplier | Sum of Margin(£)
A4E | 5489 | 4391.2 | 1097.8
A4E Ltd. (Parent) (F2F) Outside London | 2861 | 2288.8 | 572.2
Barnsley Hospital NHS Foundation Trust | 6748 | 5398.4 | 1349.6
Barnsley PCT | 3630 | 2904 | 726
[NAME] (DWP) | 3741 | 2992.8 | 748.2
Calderdale and Huddersfield NHS Foundation Trust | 3180 | 2544 | 635.9999999999999
Camberwell Green Jobcentre Plus (DWP) | 5755 | 4604 | 1151
Cardiff Local Pension Service (DWP) | 3697 | 2957.6 | 739.4000000000001
[NAME] (DWP) | 7232 | 5785.6 | 1446.4
[NAME] (DWP) | 6092 | 4873.6 | 1218.4
Ealing Hospital NHS Trust | 2472 | 1977.6 | 494.4000000000001
East Kent Hospitals NHS Trust | 8457 | 6765.6 | 1691.4
[NAME] (DWP) | 6378 | 5102.4 | 1275.6
[NAME] (DWP) | 8268 | 6614.4 | 1653.6
Great Ormond Street Hospital for Children NHS Trust - F2F. | 4554 | 3643.2 | 910.8000000000002
[NAME] (DWP) | 9088 | 7270.4 | 1817.6
High Wycombe Pension Service (DWP) | 7164 | 5731.2 | 1432.8
HMP Gartree | 6601 | 5280.799999999999 | 1320.2
Home Group - Stonham | 4462 | 3569.6 | 892.3999999999999
[NAME] Spring Pension Service (DWP) | 5537 | 4429.6 | 1107.4
[NAME] (DWP) | 6338 | 5070.4 | 1267.6
LB Camden - Adult Social Care- reviews team (F2F) | 4688 | 3750.4 | 937.6000000000001
LB Camden - Central Services_Corporate Communication team (F2F) | 5082 | 4065.6 | 1016.4
LB Camden - CSF_ Harmood Children’s Centre (F2F) | 5912 | 4729.6 | 1182.4
LB Camden - CSF_Euston Children's Centre (F2F) | 5219 | 4175.2 | 1043.8
LB Camden - CSF_KTW (F2F) | 8714 | 6971.2 | 1742.8
LB Camden - Culture and Environment_Community Safety (F2F) | 6011 | 4808.8 | 1202.2
[NAME] homes (F2F) | 4338 | 3470.4 | 867.6000000000001
LB Camden - HASC_Business Support Team (F2F) | 6608 | 5286.4 | 1321.6
LB Camden - HASC_Occupational Therapy (F2F) | 7071 | 5656.8 | 1414.2
LB Camden- HASC_engagement and research team (F2F) | 6001 | 4800.8 | 1200.2
LB [NAME] Community Services | 7763 | 6210.4 | 1552.6
[NAME] | 5660 | 4528 | 1132
[NAME] and [NAME] | 5999 | 4799.2 | 1199.8
[NAME] | 5807 | 4645.6 | 1161.4
[NAME] and [NAME] | 7213 | 5770.4 | 1442.6
[NAME] | 8992 | 7193.6 | 1798.4
[NAME] | 8015 | 6412 | 1603
[NAME] | 5552 | 4441.6 | 1110.4
MoJ Shared Services | 5456 | 4364.8 | 1091.2
Moorfields Eye Hospital NHS Foundation Trust | 3905 | 3124 | 781
Newcastle Upon Tyne NHS Foundation Trust - Cancer/Haematology | 5271 | 4216.8 | 1054.2
Newcastle Upon Tyne NHS Foundation Trust - Dermatology | 5686 | 4548.8 | 1137.2
Newcastle Upon Tyne NHS Foundation Trust - ENT | 6512 | 5209.6 | 1302.4
Newcastle Upon Tyne NHS Foundation Trust - Main Out-Patients | 5068 | 4054.4 | 1013.6
Newcastle Upon Tyne NHS Foundation Trust - Neurosciences | 9149 | 7319.2 | 1829.8
Newcastle Upon Tyne NHS Foundation Trust - Renal Services | 5509 | 4407.200000000001 | 1101.8
Newcastle Upon Tyne NHS Foundation Trust -Ophthalmology | 5520 | 4416 | 1104
Newcastle Upon Tyne NHS Foundation Trust -Plastics | 4174 | 3339.2 | 834.7999999999998
Newcastle Upon Tyne NHS Foundation Trust -Rehabilitation | 7193 | 5754.4 | 1438.6
North Middlesex University Hospital Trust- Accute and General Medicine | 6355 | 5084 | 1271
North Middlesex University Hospital Trust- Specialist Medicine and Support Services | 5056 | 4044.8 | 1011.2
North Middlesex University Hospital Trust- Women's and Childrens | 3247 | 2597.6 | 649.4000000000001
Northampton General Hospital - Clinical Oncology (NHS) | 4443 | 3554.4 | 888.5999999999999
Northampton General Hospital - General Surgery (NHS) | 2941 | 2352.8 | 588.2
Northampton General Hospital - Head and Neck & Ophthalmology (NHS) | 8842 | 7073.6 | 1768.4
Northampton General Hospital - Medicine A&E (NHS) | 6088 | 4870.4 | 1217.6
Northampton General Hospital - Trauma and Orthopaedics (NHS) | 6000 | 4800 | 1200
Nottingham University Hospitals NHS Trust - Acute Medicine | 7196 | 5756.799999999999 | 1439.2
Nottingham University Hospitals NHS Trust - Diabetes, Infectious Diseases, Renal and Cardiovascular | 6491 | 5192.799999999999 | 1298.2
Nottingham University Hospitals NHS Trust - Family Health | 4255 | 3404 | 850.9999999999998
Nottingham University Hospitals NHS Trust - Head & Neck | 4574 | 3659.2 | 914.7999999999997
Nottingham University Hospitals NHS Trust - Musculoskeletal & Neurosciences | 6189 | 4951.2 | 1237.8
Places for People - Bristol | 3851 | 3080.8 | 770.2
Royal Berkshire Hospital NHS Foundation Trust - Maternity Division | 4929 | 3943.2 | 985.8
ROYAL FREE HAMPSTEAD NHS TRUST | 6513 | 5210.4 | 1302.6
Royal Wolverhampton Hospitals NHS Trust | 9254 | 7403.2 | 1850.8
Scarborough & North East Yorkshire Healthcare NHS Trust | 7777 | 6221.6 | 1555.4
Slough Jobcentre Plus (DWP) | 8894 | 7115.200000000001 | 1778.8
South London Healthcare NHS Trust | 4595 | 3676 | 919
South West Essex PCT (HQ) (NHS) | 3279 | 2623.2 | 655.8000000000001
Staffordshire and West Midlands Probation Trust - BSL | 5022 | 4017.6 | 1004.4
Swindon Local Pension Service (DWP) | 6717 | 5373.6 | 1343.4
TAUNTON BRENDON HOUSE JCP (DWP) | 3560 | 2848 | 712
The Rotherham NHS Foundation Trust - Main Outpatient Department | 4124 | 3299.2 | 824.8
The Rotherham NHS Foundation Trust - Obstetrics & Gynaecology | 6574 | 5259.200000000001 | 1314.8
The Rotherham NHS Foundation Trust - Radiology | 6849 | 5479.2 | 1369.8
The Rotherham NHS Foundation Trust - Urology | 4878 | 3902.4 | 975.5999999999999
The Royal Marsden NHS Foundation Trust - NHS | 5602 | 4481.6 | 1120.4
Warrington and [NAME] | 6891 | 5512.799999999999 | 1378.2
Warrington and [NAME] Care | 6315 | 5052 | 1263
Warrington and [NAME], Childrens and Support Services | 4162 | 3329.6 | 832.4000000000001
West Middlesex University Hospital NHS Trust | 7130 | 5704 | 1426
Yeovil District Hospital NHS Foundation Trust | 3797 | 3037.6 | 759.4000000000001
York Hospitals NHS Trust | 8459 | 6767.2 | 1691.8
Grand Total | 496681 | 397344.7999999999 | 99336.2