Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Assuming your Dimension name is SECTEURS, try this:
=Max(Aggr(Count([No product]), SECTEURS))
Something like max(aggr(count( SomeField ), Dim1, Dim2,..., DimN)) where Dim1, Dim2, ..., DimN the dimensions are over which the count is calculated.
I would like to retrieve it in a text object.
I enter &max (aggr (count (SECTORS) [NumProduct])) & but it makes me value 1.
Try this may be:
FirstSortedValue(Aggr(Count(SECTORS), NumProduct), -Aggr(Count(SECTORS), NumProduct))
This does returns nothing.
Would you be able to share a sample?
A sample of? Table?
The table is the following :
The formula for 205 and 190 is : count([No product])
Assuming your Dimension name is SECTEURS, try this:
=Max(Aggr(Count([No product]), SECTEURS))
Thank you very much, It recovers the maximum. But is it possible to get to what sector it has reached the maximum?
Sure:
Try this:
=FirstSortedValue(SECTEURS, -Aggr(Count([No product]), SECTEURS))