Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a graph like this to show the Values for Current Year and Previous Year. The values are showing correctly as per formula.
But the label above the Previous Year value still shows the Current Year-Month name. How can we show it as Aug 2014?
Current Year set analysis: [Invoice Date]={">=$(=date(v_start_date, 'MM/DD/YYYY'))<=$(=date(v_end_date, 'MM/DD/YYYY'))"}
Previous Year set analysis: [Invoice Date]={">=$(=addyears(date(v_start_date, 'MM/DD/YYYY'),-1))<=$(=addyears(date(v_end_date, 'MM/DD/YYYY'),-1))"}
You can give name of label dynamic as below
=Date(MonthStart(Today(),-12),'MMM YYYY')
or
=Date(MonthStart(Max(MonthYear),-12),'MMM YYYY')
HI Manish,
Thanks for the help.
But in the dimension/label, we have a common and single field - MonthYear to support both the expressions.
Will that support both?
Provide sample QVW