Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In a Pivot Table I have added Type,Weekday(Sun,Mon,Tue...) as Dimensions and Count(Events) As "Expression".
Now my requirement is have to display Top3 Weekdays as "Green Color" and Remaining weekdays as "Blue color".
Can any one please help me to do.
Thanks.
It would be good to suggest if you provide the sample.
May be this:
=If(Sum(Aggr(Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>} EVENT_NUMBER), CDTS_WeekDay))>= Max(TOTAL Aggr(Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EVENT_NUMBER), CDTS_WeekDay), 3), RGB(155,187,89),RGB(149,179,215))
=If(SecondaryDimensionality() = 1, If(Count(TOTAL <CDTS_WeekDay>{<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>} EVENT_NUMBER) >=
Max(TOTAL Aggr(Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EVENT_NUMBER), CDTS_WeekDay), 3),
RGB(155,187,89),RGB(149,179,215)))