How to Display >=10 Values in Pivot Table Column?

[khasimvali85]

Hi,

Any one Can Help me How to Display >10 Values in Pivot Table Column

my out put is

No.of Calls             Call No                         >10 Calls

10                     9966210476,9866210231     5,5

7                        9876747466,7853464773     4,3

[khasimvali85]

Hi Perumal,

I don't Need Background Colour i need only >3 Reminder Call Expression Values should be in Red

But Condition is In this Expression >3 Values Display in Red.

Ex:  >3 Reminder Call

        1,1,1,3,3,5,5,8,5,9,10

above example i want to display 5,5,8,5,9,10 in Red Colour

[khasimvali85]

Hi Perumal,

Is it Possible to Display >3 values in RED Color?

[sunilkumarqv]

Try like this

=aggr(if(rank(sum(calls))<=10,DimesionName),Red())

[khasimvali85]

Hi Sunil,

Where we use this Expression?

[khasimvali85]

Hi Sunil,

This Expression is not working

[khasimvali85]

Hello Perumal,

You have any Idea about that Requirement?

did you find anything?

[khasimvali85]

Hi Perumal,

Did you Find the Solution for given requirement?

This requirement need very urgent

[khasimvali85]

Hi Perumal,

Already i have been using from last two days but i didn't get the actual so i given the expression like this

is this expression is Correct r not?

if(Concat(AGGR(SUM({<ReminderDate={'$(=vReminder)'}>}ReminderCall),RemComplaintNo),';') >3, Red(),Black())

[khasimvali85]

Hi Perumal,

Still I Didn't Get Exact What Should i Give the Expression In BackGround Color?

Give me Suggession