Top two rank over two dimensions

[#1]

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!!

[Joaquin_Lazaro]

Hi:

Look the Rank() function on the help file

Hope it helps

Joaquín

[sunny_talwar]

May be a calculated dimension:

=If(Aggr(Rank([sum(Subscribers)]) <= 2, Year, Area), Area)