How to show the USA\India\Japan data to below format

[#1]

Hi Guys,

Please tell me the how to show the  USA\India\Japan data to below order..

USA

India

Japan

[matt_crowther]

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

USA, 0

India, 1

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

[#3]

I am supposing that u have a field let say 'Country' in which the value is 'USA\India\Japan'

Use this: Subfield(Country,'\') as CountryList;

[#4]

Hey, the belo data comes from database.

Example:

India/AP/Hyderbad

India/KA/Bangalore

India/KA/Bangalore/IBM  -------

we need to display the data like

India                India                     India

AP                   KA                        KA

Hyderabad      Bangalore             Bangalore

IBM

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.

Thanks,

BA.Kumar

[#5]

Hi!

I need to know one thing that are all these:

India/AP/Hyderbad

India/KA/Bangalore

India/KA/Bangalore/IBM  -------

values of 1 Field.

can u upload some sample data.

[suniljain]

Can I know in which objcet you want to dispaly data ?.