Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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?
Thank you for your answers
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