Month Name as text in chart dimension

[martynlloyd]

I'm using NPrinting to output a chart to a spreadsheet, my problem is that the month dimension is output as numeric (dual field).

I've tried using =SubField(MonthNames,';',KPIMonth) as my dimension, but it gives an allocated memory error.

Am I using the wrong syntax?

Regards,

Marty.

[sasiparupudi1]

try

Month(KPIMonth)

[#3]

That is a string function and it will not work on dimension as it will change it.

The best option is to make a non numeric dimension during load and use it as the dimension in your chart.

If the syntax of KPIMonth is a date syntax, then you can add the following field in your load

MonthName(KPIMonth) as New_KPIMonth,

and use New_KPIMonth in your chart.