Hi,
You have to filter it by employee or you can add a column and make it part
of the PT where you enter for example Y for thouse with cell and N for the
others then when filtering the PT you choose only the Y

if this helps please click yes, thanks

"Manny" wrote:

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.