Pivot table - "top 10 function"

[mamar]

Hi,

I want to have a pivot table displaying only the top 10 highest value of a
table.
Issue : in this table, I have 12 items, with the same value (and they are
the highest).
When I use the "top 10" function of the pivot table, it displays the 12
values ... how could I "shrink" it to 10 anyway ?
Thanks in advance.

 

[bj]

what criteria will you use to decide which ten to show?

 

[mamar]

Probaly "oldness" of the item (it's another column of my table)

 

[bj]

What I have done in that case is added a helper column
with something like
=countif(main-range,value) + "OLD" VALUE/ HIGH NUMBER
set up a second helper column
=main range value+ first helper range value/ divided by another high number
select your top ten from this column making sure it is formated so that the
added number does not show in your table.