Set analisys for top values in pivot table

[stantrolav]

How can I bring TOP 8 values ​​for the given expression and 2 additional values ​​specified manually in the pivot table? I think i should use set analisys in dimension or expression.

I got 25 values of Product. To every product i have Amount. In pivot tabe i used Product as dimension and expression sum(Amount).

How can i get something like this:

Product	sum(Amount)
INHALIPT	2356
ANTI ANGIN	2145
HEXORAL	1876
CAMETON	1500
STOPANGIN	1400
TANTUM VERDE	1238
STREPSILS	786
FALIMINT	652
SEPTOLETE	23
STREPSILS PLUS	6
Others	769

Could someone help with this simple task?

[stantrolav]

That's it. Ok. Here is final answer from FABRICE44

Dimension:

=Aggr(If(Rank(Sum([Amount]))<=8 or Product='microscope' or Product='backgammon', Product, 'Others...'), Product)

Sort order:

=Aggr(If(Rank(Sum([Amount]))<1000, Sum([Amount]),-1), Product)

We use 1000 in sort order to specify that Others... should be the last from at least of 1000 values.