Color 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 help on my above post .I tried everything that I could but it's not working for me ...

Thanks in advance 

John 

[smilingjohn]

Hi All,

Tried with all the possibilities but I am. It able to get this .hoping any advice and help 

Thanks