Hi,
I have the data like below,
| customer | product | sales | Year |
| A | shoe | 2000 | 2008 |
| B | Mirror | 5000 | 2008 |
| C | IronBox | 3000 | 2008 |
| D | Light | 1000 | 2008 |
| E | Lamp | 500 | 2009 |
| E | Cable | 200 | 2010 |
| E | Ironbox | 1000 | 2008 |
| G | Char | 3500 | 2010 |
| G | TV | 5000 | 2009 |
| A | Paper | 6000 | 2010 |
In that data I need to find the maximum sales year of the customer. I need the output as below
The Required Output is
Customer Product Sales Year MaximumSaleYear
A shoe 2000 2008 2008
B Mirror 5000 2008 2008
C IronBox 3000 2008 2008
D Light 1000 2008 2008
E Lamp 500 2009 2008
E Cable 200 2012 2008
E IronBox 1000 2008 2008
G Char 3500 2010 2009
G TV 5000 2009 2009
A Paper 6000 2010 2010
I need the required outptut in straight table or in backend script..
Thanks in Advance..
