Hi I have two tables.
Table A has ID, IDName ( Both ID and IDNumber are Int datatype)
Table B has ID, Sum ( ID and Sum are String Data type)
In my Script Load
i converted the ID
Num#(ID) from Table B
but im not able to sort the SUM in the report.
With ID as above, you do not need convert to number for sorting
Please check Sort Property panel and make sure ID column on Top
An Pham, Thanks for the reply. I did that analysis didnt work for me.
You stated ID and Sum both are in String Format,then you will also have to do Num#(Sum) to convert it into Number Format.
TShraddha Thanks for the reply,
Ya i apply the Num#() to both the fields. But Sorting not working with sort function where sorting working with Alphabets of String.
Can you share sample app?
Else provide Screenshots of what you have done in chart
try in sort tab
Retrieving data ...