Hi everyone,
I'm having some trouble with a Pivot Table problem. The data I'm working with is organized in the columns: Employee ID, Region, Product, Profit Margin Per Unit, Volume Sold. I am trying to find the average total profit per employee. So essentially, I need to find the total profit for each employee by multiplying profit margin per unit by volume sold for each product and summing that number. Then getting an average per employee. I have been instructed that I can use a calculated field to make these calculations, but I have no idea how to do it.
I have tried to make a calculated field multiplying Profit Margin Per Unit and Volume Sold, but I get stuck at that point.
I'm having some trouble with a Pivot Table problem. The data I'm working with is organized in the columns: Employee ID, Region, Product, Profit Margin Per Unit, Volume Sold. I am trying to find the average total profit per employee. So essentially, I need to find the total profit for each employee by multiplying profit margin per unit by volume sold for each product and summing that number. Then getting an average per employee. I have been instructed that I can use a calculated field to make these calculations, but I have no idea how to do it.
I have tried to make a calculated field multiplying Profit Margin Per Unit and Volume Sold, but I get stuck at that point.
