1 of 1 people found this helpful
Create a calculated field: Category Performance =
IF SUM([Sales]) > WINDOW_AVG(SUM([Sales])) THEN "Above average"
ELSEIF SUM([Sales]) < WINDOW_AVG(SUM([Sales])) THEN "Below average"
Now you can drop this on the color button / shelf.
This formula includes table calc that averages the SUM(Sales) value for all categories---if you have 10 categories, it's averaging 10 values.
That sounds like what you want, but if you want to know if the average sale for a category is above the company average sale, you would use AVG(Sales) > TOTAL(AVG(Sales). AVG(Sales) will be calculated for each cell and TOTAL(AVG(Sales)) will be computed across the entire data set----as if you moved sales to a new view and selected AVG. ...
That worked, thanks a lot Jim