WITH
SET MYROWS AS FILTER(
EXISTING([Car Models].[Car Models By Brands].members),
([Measures].[Measures].[Margin]<>0))
MEMBER [Measures].[Y-1 Margin]
AS SUM(PARALLELPERIOD([Time].[Time].[Year Code],1,[Time].[Time].CURRENTMEMBER),[Measures].[Margin])
MEMBER [Measures].[Y-1 YTD Margin] AS SUM(YTD(PARALLELPERIOD([Time].[Time].[Year Code],1,[Time].[Time].CurrentMember)),[Measures].[Margin])
MEMBER [Measures].[Y YTD Margin] AS SUM(YTD(PARALLELPERIOD([Time].[Time].[Year Code],0,[Time].[Time].CurrentMember)),[Measures].[Margin])
SELECT NONEMPTY({LASTPERIODS(Month(Now()), STRTOMEMBER('[Time].[Months].[Month Code].&'))*MYROWS}) ON ROWS,
{[Measures].[Margin], [Measures].[Y-1 Margin],[Measures].[Y-1 YTD Margin],[Measures].[Y YTD Margin]} ON COLUMNS
FROM [Sales and Stock]
WHERE ([Is New Car].[Is New Car].&[1],parameter0)
אני צריך לקבל נתונים בצורה כזאת אם אני בספטמבר אז אני צריך לראות נתונים רק מינואר עד ספטמבר
