2 Replies Latest reply: Aug 25, 2017 4:09 PM by Michael Rainey RSS

    Set Analysis Exclude one field but Include another

    Michael Rainey

      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.