Top 2 company over past 3 years and 2 Years

[#1]

Hello Everyone,

I have a table with following Field

Vendor	Item	Sales	year
AB	P1	2000	2001
BC	P2	3000	2002
CD	P3	4000	2003
DE	P4	4500	2004
EF	P5	2000	2005

Then my query is to find Top 2 Vendor over 3 years,please help me out.. if anyone has any solution.

[#2]

Does that mean, you want Top 2 vendor for each year? Your question is not clear. Please explain

[jonathandienst]

Hi

This is one way:

Top =Max(Aggr(Sum(Sales), Vendor, Year))

2nd =Max(Aggr(Sum(Sales), Vendor, Year), 2)

HTH

Jonathan

[#4]

No I want top 2 vendor for over 3 Years,

and then in another table top 2 vendor for over 2 Years

[jonathandienst]

And this is another (eg in calc dimension):

     =If(Rank(Aggr(Sum(Sales), Vendor, Year)) <= 2, Vendor)

[venkatg6759]

Check the attachment if that helps.

[#7]

I have used different personal edition could you please write the code here..