Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement where I have to show top two ranks based on two dimensions. For example:
Year | Area | sum(Subscribers) |
---|---|---|
2011 | A | 1000 |
2011 | B | 1800 |
2011 | C | 1300 |
2012 | A | 1100 |
2012 | B | 1850 |
2012 | C | 1900 |
I have Year and Area as dimensions, while Sum(Subscribers) in an expression. Required result:
Year | Area | Sum(Subscribers) | Rank |
---|---|---|---|
2011 | B | 1800 | 1 |
2011 | C | 1300 | 2 |
2012 | C | 1900 | 1 |
202 | B | 1850 | 2 |
So, how to find top 'n' ranking based on more than one dimension?
Thank you!!
Hi:
Look the Rank() function on the help file
Hope it helps
Joaquín
May be a calculated dimension:
=If(Aggr(Rank([sum(Subscribers)]) <= 2, Year, Area), Area)