display the rank of a particular country

[inu]

Hi
Now i want to display the rank of a particular country. Such as india comes in rank=8 . i want to see that rank, because i dont know india's rank.
Could you plz help me out.

Thanks
Inam

[MFGF]

Didn't you already ask this in another thread??

Just add a your Country item, a measure and a query calculation using the rank summary (eg ranl([Your measure]) ) to your list. It will display the rank for each country.

Cheers!

MF.

[inu]

HI
But i want to display the rank of some country, is it possible or not.
If possible then please give me some suggestions or tips. How to resolve this problem. I tried giving filter to the country but could get the desired result, After that what i did, i added one more query calculation and set the property as "after auto aggregation".

Warm Regards
Inam

[Francis aka khayman]

can't understand what you are trying to say... can't help unless you clearly state the problem

[inu]

Hi
1.Suppose rank of india=8 , but it is not known to me, how can i display the corresponding rank. is it possible or not.
2.If we take one prompt displaying all the country, if i select one country , it should display the rank of the same.

Both question is same, but for the first one, i just hard code into the expression. And second one dynamically gives the result.

thanks and regards
Inam

[Lynn]

It sounds like your question has been answered already in this and in your previous thread. Use the rank function along with the relevant items you want to see ranked.

I'm not sure I totally follow your new point 2, but if you select one country from a prompt and filter your data based on that selection then the rank will always be 1 because you've excluded everyone else. So if you want to exclude all but one country from the layout but base the rank on data from all the countries then don't apply the filter in the query. Apply a conditional style to suppress the display of all but the country selected. Attached is an example from the Cognos sample data.

If this isn't what you were after, then it might help if you mock up an example or illustration of some sort. Mock up an example in Excel perhaps. Creating something with the Cognos sample data is also a really a good technique to clearly explain what you are trying to do.