Conditional Formatting Rules for Icon Sets

Hi,

The following pivot table has been created using Conditional formatting Icon Sets :

However, the Default Formatting Rule applied by Excel is not understood. Following is the screen shot of Formatting Rules:

Under the Formatting Rule Section:

01. The Green Icon is applicable when the value is >= 67 %

02. The Yellow Icon is applicable when value is < 67 % but >= 33%

03. The Red Icon is applicable when the value is less than 33%. 

The above Rule is clear but in my following pivot table data I have not achieved 67% or 33% of Total Revenue. Pls take a look of the screen shot :

In Column E , Sales_Amount / Grand Total does not achieve 66% or 33%. All values are less than 33%. But Icons in Col B are appearing in Red, Green and Yellow. 

Pls let me know what is the logic behind the application of Icon Sets in Col B (Sum of Sales Amount). 

However, Same Default Formatting Rule is applied in Col D (Sum of Dollar per Hour). Pls see the screen shot below:

However, it is not clear on which amount 67% and 33% are getting calculated. In Pivot Table CALIFORNIA has Dolloar Per Hour ( Sales Amount / Contracted Hours) 68.30 and it is getting Yellow Icon. 

Pls let us know the logic / Calculation of : 67% and 33% for Dollar per Hour. 

I have also attached the Excel file for reference. 

Regards,

Somnath6309