Limit dimension in pivot table

[#1]

Hello.

Does anyone know how to limit the display of one dimension in a pivot table to first 10 items ?

For instance, I want to display only the 10 most important countries in terms of measure in the pivot table below ?
Is this possible?

Thank you very much.

Institute	Country	FRANCE	ETATS-UNIS	ALLEMAGNE	ROYAUME-UNI	ITALIE	ESPAGNE	CANADA	SUISSE	BELGIQUE	PAYS-BAS	CHINE	JAPON	SUÈDE
P150		40000	6000	4000	3500	3000	2500	2000	1950	1900	1850	1350	1200	1100

[SunilChauhan]

select the aoptions as in snap

[Anonymous]

But Pivot table there is no dimention limit tab...so how to display top 10 dimension in pivot table?

[phaneendra_kunc]

TRy a RANK function

http://community.qlik.com/thread/97979

[tresesco]

You have to use rank() function possibly in combination with aggr(). Somehting like:

=Aggr( If( Rank(Sum(Sales))<11, Country), Country)  , in calculated dimension. Then check 'Supress When Value is Null' in the dimension tab.

[VENKY_A]

I want to restrict based on month name. I have dimension Month and I have to show only last 6months. How can we achieve this?