Month Year not getting correct in the chart

[kamalqlik]

Hi friends

I am using a Line chart ....which have the dimension as calculated dimension in form of

If((year([Estimated Close Date])>2009),Month([Estimated Close Date]) & '-' & Right(year([Estimated Close Date]),2)).

when I am using the chart I get the Month year in format.

Apr-10

Apr-11

Aug-10

Aug-11..

but I want the output as

Apr-10

Aug-10

Apr-11

Aug-11.

Please give me some suggestion of how to do that.

regards

Kamal

[#2]

Hi Kamal,

Try the sorting numerical -> ascending for this dimension in the Tab Sorting.

Regards

vicky

[jagan]

Hi,

Try this expression

If((year([Estimated Close Date])>2009),

     Date([Estimated Close Date], 'MMM-YY'))

Then select Ascending/Descending as required.

Regards,

jagan.

[#4]

Or try:

If((year([Estimated Close Date])>2009),Monthname([Estimated Close Date])).