Subtotal sorting

[ab3d4u]

My apology if this is a repeat question. The payroll software we used i
capable of uploading to Excel for better presentation. Afte
subtotaling, i further would like to use filtering and some other Exce
features. But this seems to be impossible. Ex. subtotal, then show leve
2 (subtotals only) then filter top ten. When I do that it shows 1
entries but not for 10 different employees. For the two months (Jul
and August) it shows top 5 with 10 raw entires. What I want to see th
true top 10 employees not top ten entries

 

[Darrilyn]

To get the top 10 employees you could try a pivot table.

 

[ab3d4u]

My apology if this is a repeat question. The payroll software we used i
capable of uploading to Excel for better presentation. Afte
subtotaling, i further would like to use filtering and some other Exce
features. But this seems to be impossible. Ex. subtotal, then show leve
2 (subtotals only) then filter top ten. When I do that it shows 1
entries but not for 10 different employees. For the two months (Jul
and August) it shows top 5 with 10 raw entires. What I want to see th
true top 10 employees not top ten entries.

Thanks for the prompt response. I can't do a pivot table once it ha
subtotals. Different dept heads to see different (selected) part of th
same report. May be I should have made this clear from the start