I have a simple query showing customer net invoice value by month and work type. What I would like to do is to summarise the data so that for every customer I see the net invoice value for each work type for each month.I would like to see this as: Group, Customer, Period and then the individual work types, of which there are always 8, as columns with the net invoice value under each of them. How can I accomplish this best?Sample code and results are below:select [Group], [Customer], [Period], [Work_Type], Isnull([Invoiced],0) [Net] from vw_R_Damages
Group Customer Period Work_Type Net------------------------------------------------------------ ------------------------------------------------------------ --------------------------------- -------------------- ---------------------JARVIS CONTRACTING LIMITED JARVIS CONTRACTING LIMITED 2011-12 Breakdown / Call out 0.00JARVIS CONTRACTING LIMITED JARVIS CONTRACTING LIMITED 2011-12 Breakdown / Call out 0.00BARRATT BARRATT NORTHAMPTON 2011-12 Breakdown / Call out 0.00TAYLOR WIMPEY GEORGE WIMPEY NORTH THAMES 2011-12 Breakdown / Call out 0.00LEADBITTER DENNE CONSTRUCTION LIMITED 2011-12 Breakdown / Call out 0.00PERSIMMON PERSIMMON HOMES (EAST MIDLANDS) LTD 2011-12 Collection Damage 17.55MUNNELLYS SUPPORT SERVICES LIMITED MUNNELLYS SUPPORT SERVICES LIMITED 2011-12 Puncture Repair 150.00TAYLOR WIMPEY GEORGE WIMPEY NORTH THAMES 2011-12 Breakdown / Call out 0.00BLOOR BLOOR HOMES SOUTHERN 2011-12 Breakdown / Call out 0.00CHELSTEEN CONSTRUCTION CHELSTEEN CONSTRUCTION 2011-12 Puncture Repair 61.50GALLIFORD TRY IMTECH JV GALLIFORD TRY IMTECH JV 2011-12 Breakdown / Call out 0.00BARRATT DAVID WILSON HOMES NORTH MIDLANDS 2011-12 Hose 0.00BARRATT DAVID WILSON HOMES NORTH WEST 2012-01 Damage repair 10.98GLADEDALE GLADEDALE (SUNDERLAND) LTD T/A BETT HOMES 2012-12 Breakdown / Call out 0.00BARRATT DAVID WILSON HOMES NORTH WEST 2011-12 Breakdown / Call out 0.00GLADEDALE GLADEDALE (SUNDERLAND) LTD T/A BETT HOMES 2011-12 Breakdown / Call out 0.00MPG GROUP LIMITED MPG GROUP LIMITED 2011-12 Breakdown / Call out 0.00BARRATT DAVID WILSON HOMES NORTH WEST 2011-12 Breakdown / Call out 0.00WILLMOTT DIXON HOUSING LIMITED WILLMOTT DIXON HOUSING LIMITED 2011-12 Breakdown / Call out 263.04ISG PEARCE LIMITED ISG PEARCE LIMITED 2011-12 Breakdown / Call out 0.00BARRATT WARD HOMES 2011-12 Breakdown / Call out 0.00BARRATT DAVID WILSON HOMES SOUTH MIDLANDS 2011-12 Breakdown / Call out 0.00LEE MARLEY BRICKWORK LIMITED LEE MARLEY BRICKWORK LIMITED 2011-12 Breakdown / Call out 0.00COUNTRYSTYLE RECYCLING LIMITED COUNTRYSTYLE RECYCLING LIMITED 2011-12 Breakdown / Call out 0.00LEE MARLEY BRICKWORK LIMITED LEE MARLEY BRICKWORK LIMITED 2011-12 Breakdown / Call out 0.00BARRATT BARRATT DAVID WILSON SOUTHAMPTON 2011-12 Puncture Repair 54.50FORKRENT FORKRENT 2011-12 Breakdown / Call out 0.00BARRATT BARRATT EAST LONDON 2011-12 Puncture Repair 164.50BELLWAY BELLWAY HOMES ESSEX DIVISION LTD 2011-12 Breakdown / Call out 0.00BARRATT BARRATT WEST LONDON-ACCOUNTS PAYABL 2011-12 Breakdown / Call out 0.00GLADEDALE MANOR KINGDOM (SCOTLAND) LIMITED 2012-05 Damage repair 0.00BELLWAY BELLWAY HOMES ESSEX DIVISION LTD 2011-12 Breakdown / Call out 0.00OSBORN BRICKWORK LIMITED OSBORN BRICKWORK LIMITED 2011-12 Breakdown / Call out 0.00BARRATT BARRATT NORTH EAST 2012-12 Breakdown / Call out 0.00J BREHENY CONTRACTORS LTD J BREHENY CONTRACTORS LTD 2011-12 Breakdown / Call out 0.00TAYLOR WIMPEY GEORGE WIMPEY SOUTH WEST THAMES 2011-12 Breakdown / Call out 95.00BLOOR BLOOR HOMES SOUTHERN 2011-12 Breakdown / Call out 0.00BLOOR BLOOR HOMES SOUTHERN 2011-12 Breakdown / Call out 0.00TAYLOR WIMPEY GEORGE WIMPEY NORTH THAMES 2011-12 Breakdown / Call out 0.00BARRATT BARRATT NORTHAMPTON 2012-01 Breakdown / Call out 0.00COUNTRYSIDE COUNTRYSIDE PROPERTIES PLC 2011-12 Damage repair 124.19HEALTHCARE & COMMUNITY CONST. LTD HEALTHCARE & COMMUNITY CONST. LTD 2011-12 Collection Damage 80.00BARRATT DAVID WILSON HOMES SOUTHERN 2011-12 Breakdown / Call out 0.00HUTTON CONSTRUCTION LTD HUTTON CONSTRUCTION LTD 2011-12 Breakdown / Call out 0.00LEADBITTER DENNE CONSTRUCTION LIMITED 2011-12 Breakdown / Call out 0.00COWLIN CONSTRUCTION LIMITED COWLIN CONSTRUCTION LIMITED 2011-12 Breakdown / Call out 0.00PERIQUIN LIMITED PERIQUIN LIMITED 2011-12 Breakdown / Call out 0.00HIGGINS CONSTRUCTION PLC HIGGINS CONSTRUCTION PLC 2011-12 Breakdown / Call out 0.00TAMDOWN PLANT HIRE LIMITED TAMDOWN PLANT HIRE LIMITED 2011-12 Breakdown / Call out 0.00BLOOR BLOOR HOMES LTD T/AS BLOOR HOMES SOUTH WEST 2011-12 Breakdown / Call out 0.00ACE PAVING (SUFFOLK) LIMITED ACE PAVING (SUFFOLK) LIMITED 2011-12 Breakdown / Call out 0.00BARRATT BARRATT NORTH MIDLANDS 2011-12 Breakdown / Call out 0.00BARRATT DAVID WILSON HOMES NORTH WEST 2011-12 Breakdown / Call out 0.00BARRATT BARRATT NORTH MIDLANDS 2011-12 Breakdown / Call out 0.00D + J HODGE D + J HODGE 2011-12 Breakdown / Call out 0.00JEHU PROJECT SERVICES LIMITED JEHU PROJECT SERVICES LIMITED 2011-12 Breakdown / Call out 0.00GLADEDALE BETT HOMES LIMITED 2011-12 Breakdown / Call out 0.00BARRATT BARRATT DAVID WILSON SOUTHAMPTON 2011-12 Breakdown / Call out 0.00BARRATT DAVID WILSON HOMES SOUTH MIDLANDS 2011-12 Breakdown / Call out 0.00PERSIMMON PERSIMMON HOMES (ESSEX) LTD 2011-12 Breakdown / Call out 0.00FREEDOM FINANCE FREEDOM FINANCE 2011-12 Breakdown / Call out 128.59FREEDOM FINANCE FREEDOM FINANCE 2011-12 Breakdown / Call out 0.00BOWMER & KIRLAND LIMITED BOWMER & KIRLAND LIMITED 2011-12 Collection Damage 84.00QUADRANT CONSTRUCTION SERVICES LTD QUADRANT CONSTRUCTION SERVICES LTD 2012-01 Damage repair 79.13BARRATT DAVID WILSON HOMES SOUTH MIDLANDS 2011-12 Breakdown / Call out 0.00BALFOUR MANSELL CONSTRUCTION SERVICES LTD 2011-12 Breakdown / Call out 0.00BARRATT BARRATT EXETER 2012-01 Puncture Repair 0.00HOPKINS HOMES LTD HOPKINS HOMES LTD 2011-12 Breakdown / Call out 0.00BARRATT DAVID WILSON HOMES EAST MIDLANDS 2011-12 Breakdown / Call out 0.00BARRATT BARRATT EXETER 2011-12 Puncture Repair 54.50HILL PARTNERSHIPS HILL PARTNERSHIPS LTD 2011-12 Breakdown / Call out 0.00J BREHENY CONTRACTORS LTD J BREHENY CONTRACTORS LTD 2011-12 Breakdown / Call out 0.00BARRATT BARRATT SOUTHERN COUNTIES 2011-12 Puncture Repair 273.50BARRATT BDW YORKSHIRE EAST 2012-02 Glass 0.00FLAHIVE BRICKWORK LIMITED FLAHIVE BRICKWORK LIMITED 2011-12 Breakdown / Call out 0.00LEADBITTER DENNE CONSTRUCTION LIMITED 2011-12 Damage repair 430.83BARRATT BARRATT SOUTH WALES 2011-12 Breakdown / Call out 0.00BERKELEY / ST JAMES BERKELEY HOMES (CAPITAL) PLC 2011-12 Breakdown / Call out 0.00MUNNELLYS SUPPORT SERVICES LIMITED MUNNELLYS SUPPORT SERVICES LIMITED 2011-12 Breakdown / Call out 0.00BERKELEY / ST JAMES BERKELEY HOMES (CAPITAL) PLC 2011-12 Breakdown / Call out 0.00MIDDLETON AGGREGATES LIMITED MIDDLETON AGGREGATES LIMITED 2011-12 Breakdown / Call out 0.00BLOOR BLOOR HOMES SOUTHERN 2011-12 Breakdown / Call out 0.00COWLIN CONSTRUCTION LIMITED COWLIN CONSTRUCTION LIMITED 2011-12 Breakdown / Call out 0.00BARRATT BARRATT NORTHAMPTON 2011-11 Breakdown / Call out 0.00NICHOLSON (NEEDHAM) LIMITED NICHOLSON (NEEDHAM) LIMITED 2011-12 Collection Damage 17.55ALLPRESS FARMS LIMITED ALLPRESS FARMS LIMITED 2011-12 Breakdown / Call out 0.00EXCEL BRICKWORK LIMITED EXCEL BRICKWORK LIMITED 2011-12 Breakdown / Call out 0.00BARRATT BARRATT SOUTH WALES 2012-01 Glass 218.88
Many thanksMartyn
Help with Pivot of data to columns
Posted - 2015-04-22 : 12:42:57
