Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a chart like below i need output of labels like this
if someone selects month and year from box it has to change the name of columns dynamically
(present selected month (nov 2013), Next month (Dec2013) , Next 3 months (Jan 2014-Mar 2014) )
Dynamic labels plz advice
Thanks
PS
Expression for selected month: sum(Sales)
Expression for next month: sum({<yourdatefield={'=$(=addmonths(yourdatefield,1))'}>}Sales)
Expression for next 3 months: sum({<yourdatefield={'>=$(=addmonths(yourdatefield,2))<=$(=addmonths(yourdatefield,5))'}>}Sales)
donot know what you want as Total Sales? sum({<yourdatefield=>}Sales) ignoring date selection
if y and m are the year and month field
=date(addmonths(makedate(max(y), max(m)),0), 'MMMYY')
=date(addmonths(makedate(max(y), max(m)),1), 'MMMYY')
=date(addmonths(makedate(max(y), max(m)),2), 'MMMYY') & '-' & date(addmonths(makedate(max(y), max(m)),4), 'MMMYY')
If you have a date field, you can try below logic:
Nov-13
=date(MonthStart(AddMonths(Max(Date_field),0)),'MMM-YY')
Dec-13
=date(MonthStart(AddMonths(Max(Date_field),1)),'MMM-YY')
Jan14-Mar14
=date(MonthStart(AddMonths(Max(Date_field),2)),'MMMYY')
&'-'& date(MonthStart(AddMonths(Max(Date_field),4)),'MMMYY')
Regards,
Kavita