Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need a little help.
I have a line chart that as a date axis but what i want to do is just show the day and the month as I have a fiscal year picker. So example 01/04 and not have 01/04/2013 and 01/04/2014. I have got =MID(Referral_Date,1,5) and this works great in a txt box but not on my line chart I get 41365 which is an excel date. Any help or guidance is much appreciated.
Hi,
Use
if it is Dimension then use Condional Dimesion
Date(FieldName,'DD/MM')
Regards
Hi,
Use
if it is Dimension then use Condional Dimesion
Date(FieldName,'DD/MM')
Regards
Thanks Max.