Hi all,
I have requirement to have a combo chart with month-wise date vs 12 months rolling. attached the screenshot.
the screenshot dimension has to be the last 12 months and the bar has to be month-wise data and line or dot has to be 12 months rolling.
I have achieved the dimension and month-wise data but the rolling 12 months not happening
example
dim have last 12 months Jan18-dec 18-> this is achived by selecting the limitation--> fixed number--> top as 12 .
exp 1 has been achieved based on the period I select.
if(GetFieldSelections(Period)='12 Months Rolling',
sum({<Month_Year1={"$(vPeriodType)"},Month=,Year=>}[ Quantity]),
if(GetFieldSelections(Period)='YTD',
sum({<Month_Year1={"$(vPeriodType)"},Month=,Year=>}[ Quantity]),,
if(GetFieldSelections(Period)='Monthly',
sum({<Month_Year1={"$(vPeriodType)"},Month=,Year=>}[ Quantity])
)))
where my variable value is
=if(GetFieldSelections(Period)='12 Months Rolling',
'<=$(=Date(MAX(Month_Year1),'MMM-YY')) >=$(=Date(AddMonths(MAX(Month_Year1),-11),'MMM-YY'))',
if(GetFieldSelections(Period)='YTD',
'<=$(=Date(MAX(Month_Year1),'MMM-YY')) >=$(=Date(YearStart(MAX(Month_Year1)),'MMM-YY'))',
if(GetFieldSelections(Period)='Monthly',
'<=$(=Date(MAX(Month_Year1),'MMM-YY')) >=$(=Date(MonthStart(MAX(Month_Year1)),'MMM-YY'))')))
exp 2 as a line chart is not achievable where Jan 18 dimension value shd have the data from feb17-jan18 as 12 months rolling and similarly to the Feb 18 as mar17-feb18.
exp 2 is not achievable. pls suggest and help me how to achieve the 12 months rolling in this scenario.
Regards
Mano
