What is the definition of [WO per Store]?
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.
It will be helpful if you simply paste all the fields definitions so that we could see what aggregation you used and if there are any nested table calcs. I assume you have COUNT([x]) in there.
It seems like you also might need to increase the level of detail:
1. Duplicate your [store] dimension field and place it in details shelf [store (copy)]
2. Address your [Over Avg] to Advanced -> drop [store (copy)] first and then [store] into address
3. Create another calculation like this:
IF first()=0 and last()=0 then [Over Avg] ELSE IF FIRST()=0 THEN WINDOW_SUM([Over Avg]) END END
and set this outer calc to compute using [store (copy)]
See the attached 9.2 wb - Sheet2 - for reference as it is analogous to yours I guess