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




--
ab3d4u

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

"ab3d4u" wrote:


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




--
ab3d4u

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

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




--
ab3d4u