The report has one dimension brand and one expression Sum(Sales). Average of total sales should be displayed on the reprot as Total. And the background color of sales should be based on the following conditions.
Go to expressions click on the plus sign and then Background expressions. Thats how we did on one of our project. The Visual Cues also puts the expression embedded there, use multiple if statements qith RGB to set the appropriate color.