Wasnt sure how to word the question but here's the issue. I'm using Excel
2007. I have a pivottable (PT) with two rows in compact form (Employee Name,
Expense Type) with the amount summed by employee/expense type.

I filtered the Expense Type since I'm only interested on those employees
with Cell Phone Allowances but the rest of their expenses (wages, salaries,
benefits, ect.) are no longer displayed. Is there a way via filters (or
other means) within a PT to display all the expense types but for only those
employees who have Cell Phone Allowance? If this cant be done using a PT, are
there any other methods?

This can be done manually but that defeats the purpose of Excel.