Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
This is the expression i use for displaying the chart title. What i want i instead of displaying the in numbers i want to show the month name in words. So i am not sure what changes has to be done with Max(Month) in my script to get the required result.
===Max(Month) & ',' &Max(Year) &' vs ' & (Max(Month)-1) & ',' &Max(Year)& ' Sales Growth @ ' & num(Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month))}>} SalValue) / Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month)-1)}>} SalValue), '#%')
By the way i have INLINE in my script to show the month name in words. It has been given below. Check whether anything can be done with this in the above expression.
MonthName:
load * inline [
Month, MonthName
4,Apr
5,May
6,Jun
7,Jul
8,Aug
9,Sep
10,Oct
11,Nov
12,Dec
1,Jan
2,Feb
3,Mar];
Thanks and Regards,
Rikab
Hi Martin!
Thanks a ton! Exactly the one i was looking for. It works perfectly!
Regards,
Rikab