Substring in Crosstab is not working

[Pramod]

I have a dimensional model in which I have to filter row values.The row contain a data item which has a attribute name .The name contain the  code at beginning and description at the end. Since it is a string I use substring function to extract code from the name attribue . When I do it in list report I am getting the correct data but when I pivot it to crosstab the dataitem returns balnk value. Can anyone help on this ......Its an urgent requirement please help ???

[MFGF]

Seems to work OK for me.  Can you be more specific about what you are doing in the report?  Is the attribute definitely a string?

MF.