Chart Dimension Convert Month to Words

[#1]

Dear all,

I have month in my chart dimension. The data in the database for month is in '01','02','03'....

How do i convert it to words when it display in chart

I know the following formula. But how could i apply it in this instance?

upper(date(Today(),'MMMM'))

[jagan]

Hi,

Try like this

=Pick(Num(MonthDimensionName), 'Jan', 'Feb', 'Mar', ......................, 'Dec')

Hope this helps you.

Regards,

Jagan.

[#3]

Where should i type this in?

[jagan]

Hi,

Put this wherever you need like in expression, dimension script, but it is better to have this in script like this

LOAD

     *,

Pick(Num(MonthDimensionName), 'Jan', 'Feb', 'Mar', ......................, 'Dec') AS MonthName

FROM DataSource;

Now use MonthName in Dimension or Expreesion.

Hope this helps you.  If not understanding please attach sample file.

Regards,

Jagan.

[#5]

Ok.. But how do i sort the month from Jan ... Dec

[jagan]

HI,

Then try like this

TableName:

LOAD

     *,

Dual(Pick(Num(MonthDimensionName), 'Jan', 'Feb', 'Mar', ......................, 'Dec'), Num(MonthDimensionName)) AS MonthName

FROM DataSource;

Now in Sort tab select Numeric.

TableName:

LOAD

     *,

Date(MakeDate(2013, Num(MonthDimensionName)), 'MMM') AS MonthName

FROM DataSource;

Now in Sort tab select Numeric.

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

Please close the discussion if your issue is solved by giving the Correct and Helpful answers to the posts.  It helps others to find the solution for similar issues.

Regards,

Jagan.