Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can we get top 10 services based on first dimension in pivot table qliksense
use Rank function
=if(Aggr(Rank(Sum(sales)), DEPT)<=10, DEPT , 'Others')
I am using the same in the in the first dimension as calculated field, but that is not working.
not working means ,getting error or not getting expected output.
Not getting expected output.