Showing Top 10 Total

[abhaytrip]

Hi Qlikers,

Since i'm new I thought that this would be the best forum do ask questions.

Issue: I want to show the Top 10 total in the pivot table. Just like in the picture below.

But what is happening is i'm able to show only the Others Total and the Complete Total. (Like the picture below)

So how do I get the Top 10 Total and display Others with it too.

Any help regarding this would be appreciated !
Thanks ,
Abhay

[tresesco · Accepted solution]

Try like this:

Exp:  if(Dimensionality()=0,Sum({<Data={"=Rank(Sum(Data))<11"}>}Data), Sum(Data))

[abhaytrip]

Yep , This did help !

Thanks a lot.

[alis2063]

You could also simply marked the Total mode as below,

[isingh30]

Please check this. Let me know.

Expression  =sum({$<Customer ={A,B,C}>}Sales)

Thanks.