Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi All,
Tried with all the possibilities but I am. It able to get this .hoping any advice and help
Thanks