Not applicable
2014-09-05
04:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to display >1000 values in pivot table
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
700 Views
4 Replies
alexandros17
Partner - Champion III
2014-09-05
04:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
481 Views
Siva_Sankar
Master II
2014-09-05
04:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Chaganti,
Refer this thread Limit of records using a pivote table
481 Views
MayilVahanan
MVP
2014-09-05
04:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Try like this'
= Sum({<[Manager Name Lvl 04] = {"=Sum(Amount) > 10000"}>}Amount)
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.
481 Views
sujeetsingh
Master III
2014-09-05
04:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just order by it and use row no
481 Views