Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Dimension
Region
Name
Expression
If(Rank(Sum(SalesBalance)) < 11, Sum(SalesBalance))
May be this
Dimension
Region
Name
Expression
If(Rank(Sum(SalesBalance)) < 11, Sum(SalesBalance))