Top 10 Services based on first Dimension in qliksense Pivot table

[indra]

Hi,

How can we get top 10 services based on first dimension in pivot table qliksense

[anat]

use Rank function 

=if(Aggr(Rank(Sum(sales)), DEPT)<=10, DEPT , 'Others')

[indra]

I am using the same in the in the first dimension as calculated field, but that is not working.

[anat]

not working means ,getting error or not getting expected output.

[indra]

Not getting expected output.