LEFT OUTER JOIN tblP_OEE_Production_Transactions AS B ON 
Case
when @GroupBy='Work Center' and A.GroupField = B.WorkCenterID then 1
when @GroupBy='Equipment' and A.GroupField = B.EquipmentID  then 1
when @GroupBy='WIP' and A.GroupField = B.WipID then 1
when @GroupBy='Product' and A.GroupField = B.ProductID then 1
when @GroupBy='Scrap Reason' and A.GroupField = B.ReasonID then 1
when @GroupBy='Off Time Reason' and A.GroupField = B.ReasonID then 1
when @GroupBy='Team' and A.GroupField = B.UsersGroupID then 1
else 0
End = 1

SELECT		A.GroupField,
		A.GroupSum,
		b.myDateTime AS Date
FROM		(
			SELECT		CASE @GroupBy
						WHEN 'Work Center' then WorkCenterID
						when 'Equipment' then EquipmentID
						when 'WIP' then WipID
						when 'Product' then ProductID
						when 'Scrap Reason' then ReasonID
						when 'Off Time Reason' then ReasonID
						when 'Team' then UsersGroupID
					End AS GroupField, 
					SUM(Qty) AS GroupSum
			FROM		tblP_OEE_Production_Transactions
			WHERE		(FacilityID = @Facility OR @Facility = 'All')
					AND (WorkCenterID = @WorkCenter OR @WorkCenter = 'All')
					AND (EquipmentID = @Equipment OR @Equipment = 'All')
					AND (WipID IN (select Extracted from dbo.MultiValuesTable(@WIPID, ',')))
					AND (SubWipID IN (select Extracted from dbo.MultiValuesTable(@SubWIPID, ',')))
					AND (ProductID IN (select Extracted from dbo.MultiValuesTable(@Product, ',')))
					AND (UsersGroupID = @Team OR @Team = 'All')
					AND (ReasonID In (select Extracted from dbo.MultiValuesTable(@Reason, ',')) OR @Reason='No Reason')
					AND ([Type] = @DataMeasure)
					AND (mydatetime BETWEEN @FromDate AND @ToDate) 
			GROUP BY	CASE @GroupBy
						WHEN 'Work Center' then WorkCenterID
						when 'Equipment' then EquipmentID
						when 'WIP' then WipID
						when 'Product' then ProductID
						when 'Scrap Reason' then ReasonID
						when 'Off Time Reason' then ReasonID
						when 'Team' then UsersGroupID
					End
		) AS A
LEFT JOIN	(
			SELECT	Case @GroupBy
					when 'Work Center' then WorkCenterID
					when 'Equipment' then EquipmentID
					when 'WIP' then WipID
					when 'Product' then ProductID
					when 'Scrap Reason' then ReasonID
					when 'Off Time Reason' then ReasonID
					when 'Team' then UsersGroupID
				End AS GroupField,
				myDateTime
			FROM	tblP_OEE_Production_Transactions
		) AS B ON b.GroupField = a.GroupField