If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to Get the Description of Maximum Values

Started by markcognos, 18 Dec 2013 10:04:03 PM

Previous topic - Next topic

markcognos

Hi,

I have a problem to get the description of maximum values : Here is the example :

Weather |CountWather     |Maximum|MaxValue
Sunny     | 3                        | 3           |? (Must Sunny)
Sunny     | 3                        | 3           |? (Must Sunny)
Sunny     | 3                        | 3           |? (Must Sunny)
Rainny    | 2                        | 3           | ? (Must Sunny)
Rainny    | 2                        | 3           | ? (Must Sunny)

in Weather Count :
Sunny is 3
Rainny is 2.

So ill get the maximum of weather count which is 3.

How can i get the weather descripton Sunny of the maximum of 3? the value in MaxValue must Sunny.
Can anyone help?Pls...

I Need this output:

Weather |CountWather     |Maximum|MaxValue
Sunny     | 3                        | 3           |Sunny
Sunny     | 3                        | 3           |Sunny
Sunny     | 3                        | 3           |Sunny
Rainny    | 2                        | 3           |Sunny
Rainny    | 2                        | 3           |Sunny