I’m trying to create a calculation that will calculate PM & CM labor hours by week, and take the average. Then once I have the average, I’m being asked to calculate the standard deviation. I tried creating a summary table (attached), but I need the values to recalculate when slicers are selected and because this table doesn’t relate to the work order fields, it won’t recalculate.
Summary Table.xlsx (11.1 KB)