Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe this if Category is your dimension field and you've selected an employee:
Avg({<FullName=,EmployeeID=, Category = p() >}Sales)
Maybe this if Category is your dimension field and you've selected an employee:
Avg({<FullName=,EmployeeID=, Category = p() >}Sales)
P() & 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!