Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Does that mean, you want Top 2 vendor for each year? Your question is not clear. Please explain
Hi
This is one way:
Top =Max(Aggr(Sum(Sales), Vendor, Year))
2nd =Max(Aggr(Sum(Sales), Vendor, Year), 2)
HTH
Jonathan
No I want top 2 vendor for over 3 Years,
and then in another table top 2 vendor for over 2 Years
And this is another (eg in calc dimension):
=If(Rank(Aggr(Sum(Sales), Vendor, Year)) <= 2, Vendor)
Check the attachment if that helps.
I have used different personal edition could you please write the code here..