Pick the dimension with a greatest value

[Anonymous]

hi,

  for example i have the following table

  Age group       Population

   21-24                 30

   25-29                 45

   30-36                 22

    37-above          10

based from the table above, I need to make a text where i need to state that 25-29 is the age group with the biggest population.

I need to make a text box where it includes an expression that can compute for the age group diimension that has the biggest population.

Many thanks for the help.

[passionate]

Hi Ronald,

Create a Variable to have Max of Population.

Let vMax= max(Population);

Use below Set Analysis in test box:

=Only({<Population={"$(vMax)"}>}Agegroup)

Please let me know if this is what you expect.

Cheers,

Pankaj

[sergio0592]

Try with

FirstSortedValue(Age group, -Population)

[ecolomer]

Is this you need?

[sunny_talwar]

May be this if your chart expression is Count(Population) in the chart we are seeing above...

FirstSortedValue([Age group], -Aggr(Count(Population), [Age Group]))

[Anonymous]

hi, the firstsortedvalue worked,, thanks a lot.. now i can get the category with the highest value.

how about if i want to display the value instead?

instead of displaying 25-29 age group, i want to display the population which is 45.

Thanks again

[sunny_talwar · Accepted solution]

May be just this

Max(Aggr(Count(Population), [Age Group]))

or if your expression is just Population, then this

Max(Population)

[Anonymous]

thanks a lot Sunny its all working now

thanks to all who replied as well