K
kblostyankee
I am trying to generate a report with thousands of employee payroll
deductions. many have multiple invoices and need a subtotal as well as other
info included, however, I cannot figure out how to display all info on the
subtotal line. If I had that, I could filter out the individual invoices. I
need them all sorted by facility, name, and date and formated into numbers, 2
decimals. I have tried working with pivot tables, but I am not too familiar
and I also need to have formulas in subsequents columns.
Also is there an easy way to immediately delete of all of those with a zero
balance after filtering?
Can anyone help?
Thanks so much,
Kathleen
deductions. many have multiple invoices and need a subtotal as well as other
info included, however, I cannot figure out how to display all info on the
subtotal line. If I had that, I could filter out the individual invoices. I
need them all sorted by facility, name, and date and formated into numbers, 2
decimals. I have tried working with pivot tables, but I am not too familiar
and I also need to have formulas in subsequents columns.
Also is there an easy way to immediately delete of all of those with a zero
balance after filtering?
Can anyone help?
Thanks so much,
Kathleen