How can I filter a table with multiple criteria.

[littlevillage]

Hi,

I am trying to filter a Pivot table.

I have written a formula:

=INDEX(SORT(FILTER(H4:K132,I4:I132>=LARGE(I4:I132,10),""),4,-1),SEQUENCE(10),1)

I got the first result succesfully, but next step I don't know how can I get the result expect.

I have added an image and the link of sample file below

https://docs.google.com/spreadsheets/d/15myc-rwZnoCNfwSP_SSvzdHxln6mnqAa/edit?usp=sharing&ouid=11231... 

[#2]

@littlevillage 

And what rules should be applied to get from "The first result" to "The result expect"?

[#3]

@Detlef_Lewin 

Thank you for your response

Actually, I want to get the expected result directly from the pivot table, with the rule that the criteria in column K are sorted from highest to lowest combined with high values in column I. The expected result is 5 items with percentages from highest to lowest.

[#4]

@littlevillage 

So, you want the Top 5 based on field "Total Late" and sorted from highest to lowest based on field "% of late", correct?

[#5]

@Detlef_Lewin 

yes, Lewin, that's correct. That's the result expect.

[#6 · Accepted solution]

@littlevillage 

But it is not the expected result you show in the workbook.

=SORT(FILTER(FILTER(H4:K132,I4:I132>=LARGE(I4:I132,5),""),{1.0.0.1}),2,-1)

[#7]

@Detlef_Lewin 

Thank you for your help

That's the best way for this case