I'm assuming this relates to showing the coutries in the sort order you show.
You can either:
1) Load them in that order and then select 'Load Order' from the Sort tab of the Properties window.
As that isn't alway practical I'd recommend:
2) Use 'Dual' to force the order you desire - search the Help file. as a quick eg:
Load Dual (Country, SortOrder) as Country inline
[ Country, SortOrder
Japan, 2 ];
That will then allow you to sort using the 'SortOrder' field in teh table or chart as required.
Hope that helps,
Matt - Visual Analytics Ltd
Hey, the belo data comes from database.
we need to display the data like
India India India
AP KA KA
Hyderabad Bangalore Bangalore
i think we can use Index,mid and do while loop functions but i dont know how to use those functions.
Can please tell me how to use those functions and getting the results.