I've created a calculation, IF [WO per Store] > WINDOW_AVG([WO per Store]) then 1 else 0 END so that I can count when a location has more than the average, and I want to view how many locations in total are above the average. But when I put this in a table, all the other fields total, but this ends with 0, even though the table above will have values. I hope I've explained it well. All I can provide is a screenshot.

Work Order per Store. I’ve figured that the average store has 28 work orders, but I want a count of how many stores are over the average. And that average is dynamic, so based on what filters we may use, it’ll change. And then we’ll want that total to also change.