Color Filtering on a Straight table

[HQPGPXS]

Hello,

I am working on filtering a straight table using a calculated background color conditions.    

Step 1:  First I created a calculated color filter dimension with values being "Green", "Yellow", and "Red" 

Script:

=Aggr(IF({<Country, Part number>}(Sum(Sales) - Total_Orders)  <=  0  OR  (Sum(Sales)  <=  0,  'Red',

              IF({<Country, Part number>}(Sum(Sales) - Total_Orders)  <  Total_Stocks  OR  Sum(Sales)   <  Total_Stocks , 'Yellow',

                        'Green')), Country, Part number)

Step 2:  I applied the same color condition scripts to create a background color on a Total Sales column in a straight table.

=Aggr(IF({<Country, Part number>}(Sum(Sales) - Total_Orders)  <=  0  OR  (Sum(Sales)  <=  0,  'Red',

              IF({<Country, Part number>}(Sum(Sales) - Total_Orders)  <  Total_Stocks  OR  Sum(Sales)   <  Total_Stocks , 'Yellow',

                           'Green')), Country, Part number)

Now , the issue is when I filter by color "Yellow" or "Green" or "Red" only, I am still seeing the other colors in the columns.

Any suggestions will be much appreciated!