How to show data based on pivottable filter?

[Manny]

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.

 

[Eduardo]

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]

Both of the options suggested require for the employees to be manually
identified and seperated from those that dont have a particular expense type.


Just to confirm, there's no way of doing what I want without resorting to
adding a column to the raw data and making that additional column part of the
PT? Or manually selecting the employees from the PT filter?

What I'm trying to do is show all the expenses for employees with Cell Phone
Allowances in a PT from a single data set that includes employees who dont
have that allowance without having to alter the raw data.