Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be just this
Max(Aggr(Count(Population), [Age Group]))
or if your expression is just Population, then this
Max(Population)
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
Try with
FirstSortedValue(Age group, -Population)
Is this you need?
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]))
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
May be just this
Max(Aggr(Count(Population), [Age Group]))
or if your expression is just Population, then this
Max(Population)
thanks a lot Sunny its all working now
thanks to all who replied as well