3 Replies Latest reply: Dec 15, 2011 2:32 PM by Marc Livingston RSS

    Month Year not getting correct in the chart

    Kamal Naithani

      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