Can you post a workbook with a small dataset, it will be easier to answer you question.
Unfortunately I am working on confidential data.SO cant share.Also, the data file is 450MB(huge), hence cleaning data for this will itself require humongous effort.
Anyway,this is what my logic is :
IF (((COUNTD([SiteSerial])) / (TOTAL(COUNTD([SiteSerial]))))) >((SUM([Calc R SITE Quarter]))/(SUM([Calc SITE Quarter])))then "Bright Red"
ELSE "Light Blue" END
Calc R SITE Quarter
Calc SITE Quarter
are both calculated using fixed function.(countd)
Color coding is not reflecting correctly in the final chart.
You must start by creating 4 calculated fields with the 4 segments of the equation.
Doing that will help you see, why you're not getting the desired result.
Add a column With the equation Column A > Column B to see what it shows.
Do that by referencing the 2 calculated fields.