SELECT 
case [Model] 
WHEN 'Mountain-100' THEN 'M200' when 'Road-150' THEN 'R250' when 'Road-650' THEN 'R750' 
WHEN 'Touring-1000' THEN 'T1000' ELSE LEFT(Model, 1) + Right([Model], 3) 
END + ' ' + [Region] AS [ModelRegion] ,(convert(Integer, CalendarYear) * 100) + CONVERT(int, Month) AS [TimeIndex] 
,SUM(Quantity) AS [Quantity] 
,sum(Amount) AS Amount, calendaryear,[Month]
,[dbo].[udfbuildiso8601date] ([CALENDARYEAR], [Month], 25)
as reportingdate
FROM [dbo].[vDMPrep] 
where [Model] IN ('Mountain-100', 'Mountain-200', 'Road-150', 'Road-250', 
'Road-650', 'Road-750', 'Touring-1000') 
GROUP BY CASE [Model] 
WHEN 'Mountain-100' THEN 'M200' WHEN 'Road-150' THEN 'R250' WHEN 'Road-650' THEN 'R750' 
WHEN 'Touring-1000' THEN 'T1000' ELSE Left(Model,1) + Right(Model,3) 
end+' '+[Region] ,(Convert(Integer, [CalendarYear]) * 100) + Convert(Integer, [Month])
,CalendarYear,[Month],[dbo].[udfBuildISO8601Date] ([CalendarYear], [Month], 25);