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 ???
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.