How to display >1000 values in pivot table

[#1]

Hi iam using below expression for calucating the amount

if( aggr( rank(  sum(Amount)),[Manager Name Lvl 04]) , sum(Amount))

and now i want to display only >10000 values

please help me on that

thanks

[alexandros17]

In each expression set a condition on the field you need above 1000:

for example :

if(sum(myVal) > 10000, Sum(thisField), 0)

then exclude all value equal to 0

[Siva_Sankar]

Chaganti,

Refer this thread Limit of records using a pivote table

[MayilVahanan]

Hi

Try like this'

= Sum({<[Manager Name Lvl 04] = {"=Sum(Amount) > 10000"}>}Amount)

[sujeetsingh]

Just order by it and use row no