Filter top 10 of filtered data

[heinecorp]

Hi,

Im wondering if anyone can help me, ive searching but couldnt find anything so im trying here.

Is it posible to filter a top * for already filtered data. E.g, i have sales people each having their total sales per month , what im trying to achieve is when i filter for only 1 person i want to get the top 10 sales months for that person.

hope ive explained enough

thanks in advance

[dilipandey]

Hi heinecorp,

welcome to the forum.

It can be achieved using formulas or may be through pivot, can you upload a sample workbook ? Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[FDibbins]

Hi and welcome to the forum

Hoe gaan dit daar ander kant die see?

If you are already filtering, you could filter on the person, then if you select filter/number filter/top 10 on SALES, that should give you what you want?

Laat my weet?