top 10 values come with rest of all values

[prma7799]

Hi All/ gwassenaar‌

I am using below expression "=if(aggr(rank((SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},MonthName=,Quarter=>}[Values]))/100000),CORPORATE)<=10,CORPORATE,'OTHERS') " for top 10 records but my requirement is i want top 10 records

but 'OTHERS' should come in below records means 11th records with Proper Sorting.

for Reference

Calculating TOP 10 VALUES in PIVOT TABLE

Thanks

[#2]

Try with Sort by expression for second dimension with decending like Sum(Values) or =if(aggr(rank((SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},MonthName=,Quarter=>}[Values]))/100000),CORPORATE)<=10,1,0)

[prma7799]

Hi,

OTHERS will go to the last row but sorting is not coming as descending order.

Thanks