Set Analysis Exclude one field but Include another

[mrainey18]

I am trying to find the average sales for one employee for each category and compare that employee to the average sales of all other employees.  BUT I only want the categories associated with the selected employee.  I dont want to have to select all the categories.

This gets me the first half:

Avg(Sales)  // For one employee

Avg({<FullName=,EmployeeID=>}Sales) // For all employees

I just now need to only display the selected employees Categories.

[swuehl · Accepted solution]

Maybe this if Category is your dimension field and you've selected an employee:

Avg({<FullName=,EmployeeID=, Category = p() >}Sales)

[mrainey18]

P() &amp; E() and where do you use them?

I'm referencing this because I've never heard of these before.  Thank you for your quick answer!