Selecting Maximum Value
Posted: Thu May 22, 2008 8:09 pm
Hello I have to sort the following data in order to geth the shop which has the biggest sales for each month for example. The first field is shop location, the second is the month and the third is total sales. Column leghts are 1,17 for locations, 19,2 for monts, 22,6 for sales
I woul like display the shop with the biggest sales for each month
Expected output
Thank you very much
london 1 300
london 2 150
milan 1 310
milan 3 120
Sacramento 2 100
Munich
london 2 150
milan 1 310
milan 3 120
Sacramento 2 100
Munich
I woul like display the shop with the biggest sales for each month
Expected output
1 milan
2 london
3 milan
2 london
3 milan
Thank you very much