Recover the maximum value in a table

[#1]

Hello or hello again,

Do you know if it is possible to recover the maximum value for counting and for what mode the maximum is reached. (in a table).

Thank you.

[Gysbert_Wassenaar]

Something like max(aggr(count( SomeField ), Dim1, Dim2,..., DimN)) where Dim1, Dim2, ..., DimN the dimensions are over which the count is calculated.

[#3]

I would like to retrieve it in a text object.

I enter &max (aggr (count (SECTORS) [NumProduct])) & but it makes me value 1.

[sunny_talwar]

Try this may be:

FirstSortedValue(Aggr(Count(SECTORS), NumProduct), -Aggr(Count(SECTORS), NumProduct))

[#5]

This does returns nothing.

[sunny_talwar]

Would you be able to share a sample?

[#7]

A sample of? Table?

The table is the following :

The formula for 205 and 190 is : count([No product])

[sunny_talwar · Accepted solution]

Assuming your Dimension name is SECTEURS, try this:

=Max(Aggr(Count([No product]), SECTEURS))

[#9]

Thank you very much, It recovers the maximum. But is it possible to get to what sector it has reached the maximum?

[sunny_talwar]

Sure:

Try this:

=FirstSortedValue(SECTEURS, -Aggr(Count([No product]), SECTEURS))