Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Chaganti,
Refer this thread Limit of records using a pivote table
Hi
Try like this'
= Sum({<[Manager Name Lvl 04] = {"=Sum(Amount) > 10000"}>}Amount)
Just order by it and use row no