Top 10 by Region

[qlikofba]

Hi,

I am looking to get a chart that displayed the Region, top 10 sales people, and the sales. 

                          Total sales

North  1. Joe         10

          2.  John       59

          3.   Kim          5    

          ...

          ..10 Kathy   15

South  Top 10 south people

West  top 10 west

East top 10 east

My dimensions are region, name,  sales Balance

Thanks

[sunny_talwar · Accepted solution]

May be this

Dimension

Region

Name

Expression

If(Rank(Sum(SalesBalance)) < 11, Sum(SalesBalance))