3 Replies Latest reply: Jun 2, 2014 5:58 PM by Boris Gerchikov

# Limit to Top 10 in Pivot Table

I have a Pivot table to counts to total number of referred physicians to Requesting physicians. How would I limit the view in this table to the Top 10 in count volume?

My dimensions are:

Requesting Phsycian

Referring Physician

My Expression is:

count(WP_CaseTable.Number)

How would I limit to top 10 by total count?

• ###### Re: Limit to Top 10 in Pivot Table

Hi Robert,

You might use the rank function:

=sum(aggr(if(rank(count(WP_CaseTable.Number))<=10,count(WP_CaseTable.Number)), [Requesting Phsycian],[Referring Physician]))

Hope it will help

• ###### Re: Limit to Top 10 in Pivot Table

Good morning! friend

I am facing  the same problem and I need your help

I try to display the first 10 sales per country in a Pivot table

so I added this expression in dimensions

and as a result I have

as you can see  for 2010 it gives a result  USA-> France-> germany  and the logical order is USA-> France-> UK

why?

• ###### Re: Limit to Top 10 in Pivot Table

Hi Hanane,

Your table is sorted by value.

Try use sort by Country in your Sort tab: in Expression box put Country as a value.

Hope it will help