Firstly, please put your code in IFCODE Tags, putting it straight into the box makes it quite difficult to read, and has no formatting.

Secondly, you've provided what you've attempted which is great, but I am having difficulty really visualising your data. Can you problem some samples, with DDL?

To save some others some time:

CREATE VIEW [dbo].[CarouselDailyMileages] AS

SELECT DATENAME(DW,J.DELDATEANDTIME) AS [WEEKDAY],

J.DELDATEANDTIME AS [DATE],

(J.colpostcode + ' , ' + J.DELLPOSTCODE + ', ' + D.POSTCODE) AS [Destination],

J.ACTUALMILEAGE AS Mileage,

J.PRICE AS [Sale Price],

CASE WHEN (SELECT COUNT (*)

FROM dbo.jobs j2

INNER JOIN driver dv2 ON dv2.DRIVERPRIMARYID = j2.DRIVERPRIMARYID

WHERE j2.DRIVERCOST = 0

AND j2.JOBID = J.JobID

AND dv2.SUBCONTRACTORINDICATOR = 0) > 0

THEN J.PRICE - (J.PRICE * .30)

ELSE J.DRIVERCOST END AS [COST PRICE],

V.VEHICLE AS [Vehicle Type],

J.JOBREFERENCE AS [Reference],

J.requestedby,

C.customerid,

Dv.employeenumber,J.JOBNUMBER,

CASE WHEN J.requestedby like '%John Deere%' THEN 1 -- Green

WHEN J.requestedby like '%FSL%' THEN 2 -- Blue

WHEN J.requestedby = 'Manroland' THEN 3 -- Orange

-- WHEN J.requestedby = 'John Deere Harvest 2016' THEN 4 --Pink

WHEN J.requestedby = 'Clothing' THEN 5 -- Grey

WHEN J.requestedby = 'Community Playthings' THEN 6 -- Red

WHEN J.requestedby = 'Siemens' THEN 7 -- Black

WHEN J.requestedby = 'Carousel Siemens' THEN 7 --Black

WHEN J.requestedby = 'Siemens - adhoc' THEN 7 -- Black

WHEN J.requestedby = 'OTRS' THEN 8 --purple

WHEN J.requestedby = 'AGCO' THEN 9 -- Navy

WHEN J.requestedby like '%Draeger%' THEN 10 --Dark Red

ELSE 20

end as referenceflag

FROM dbo.Jobs J

INNER JOIN dbo.Drops D ON J.JobID = D.JOBID

INNER JOIN dbo.Vehicle V ON J.VEHICLEID = V.VEHICLEID

INNER JOIN dbo.customer C on J.CUSTOMERID = C.customerid

INNER JOIN dbo.Driver Dv on J.DRIVERPRIMARYID = Dv.DRIVERPRIMARYID