Pivot Table - Top 3 WeekDays

[bhavvibudagam]

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.

[settu_periasamy]

It would be good to suggest if you provide the sample.

[sunny_talwar · Accepted solution]

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))

[bhavvibudagam]

=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)))