Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi,
OTHERS will go to the last row but sorting is not coming as descending order.
Thanks