Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use rank function
for example
if your expression is Count(Calls)
then sum( {< call_id={"rank(Count(Calls),4) <=10"}>} aggr(count(Calls),Call_id))
What do you mean by >10 values? Unclear from your sample also.
hi,
its Not working
Thanks,
Khasim.
Hi ,
For Examplae i have Calls like
i Want to Display like
Calls >10 Calls Red
15 10,5
19 10,5,4
13 10,3
17 10,4,2,1
22 10,10,2
above table >=10 calls should be Show in Red Color
Thanks,
Khasim.
Can you provide some sample files? It's difficult to work on your sample..
Hi
You can color single cells for single value based on the condition to be add in Background color.
eg. if(Sum(Expression)>=10,Red(),Black())
But you have used concatenation function using delimeter ','
Regards
Aviral Nag
Hi,
I used Same Condition but its showing All are Red
Thanks for Suggession
Thanks,
Khasim
As Aviral mentioned, you cannot use this kind of logic on a concatenated (string) field.
You will need to split the cells out onto their own lines using something like a pivot table, and then apply the cell background formatting.
Try like this : if(call>='10',red(),Green())
If u face any issue please post your app