Hello. See attached. I'm looking for a way to show outliers in a pivot table. The data is dead simple -- some items with process times (in days). The item may be made in one of three locations (shown across the top). What I want to do is identify the outliers. In my data set, 19E in Portland has a process time of 50 days, while it's 20 at the other locations. Item MM1 is a red flag also.
One thought was to add a column to the far right that shows the standard deviation of the process times across all locations. I can't figure out how to get the column over there. If I add an expression, it shows for each location, which makes sense, but it's not what I want. Is there a way to aggregate at that level? Or maybe a better way altogether?
