Color Code for Expression

[smilingjohn]

Hi All, 

I have a requirement to color code  one of the column by using calculated dimension. 

I use this below simple calculated dimension which  works perfectly fine . 

If( Category=SubCategory,'G','R')  This simple works for me .. But I have to use this with one of the complex expression which is below ... How can I  achieve the above expression  in below mentioned expression 

=Aggr(count(Distinct {<Status-={'Progress','On Road','1Phase'},
Demand={'VeryHigh','Popular'}>}if(Order_Date<AcceptDate and (isnull(CLOSE_DATE) or CLOSE_DATE>=AcceptDate and (PRODUCT=(Product_Sub)or PRODUCT=('null'))),ID))
+
count(Distinct{<Status-={'Progress','On Road','1Phase'},
Demand={'VeryHigh','Popular'}>}
if(Order_Date>AcceptDate and (PRODUCT=(Product_Sub)or PRODUCT=('null')),ID)),Area,Caps,[Sub-Caps],AcceptDate) 

Can someone please help me with this 

Thanks

John

[smilingjohn]

Hi Expertise

Any suggestions on  my post 

Thanks

[smilingjohn]

Hi Expertise I tried with everything that I could but this is not working for me ...

Any advice would really make a change 

Thanks in advance