Show the top 10 of the smallest values in a pivot table

[Anonymous]

Hi guys,

I would like to know how to display only the top 10 of the lowest values that my expression throws.

But even with this option does not allow me, is there any way I can show what is requested? if you have any examples that could give me would be of great help.

Thank you so much.

[vardhancse]

Hi In Dimension Limits->Select :

show only: smallest

Values: 10

In Sort Tab:

Expression: Give your expression

[Anonymous]

Hi Sasi,

I already did the indicated thing but it does not show me any record.

And my expression is:

=sum(MSEG.Importe_SOLES)*

avg(AGGR(

fabs(sum({$<[MSEG.Clase de movimiento_BWART]={'201','221','261' }>}MSEG.Cantidad_MENGE))

/

Aggr( rangesum(Above( sum({$<[Año EM],[Mes EM]=>}MSEG.Cantidad_MENGE), 1, RowNo())) ,([Periodo EM],(NUMERIC,ASCENDING)) )

,[Año EM],[Mes EM],[Material EM]))

Thank you so much.

[Anonymous · Accepted solution]

Thanks so much to everyone I found the solution: