Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is the data and I am trying to make a chart of each Salesman highest and lowest of Sales for the whole year for instance Salesman Jones the highest sales for 2012 is January the amout is 1353 and the lowest is Feb the amount is 73 and for the Invoice for the year 2012 the lowest is April the count of invoice is 1 and the higest is Jan 3.
How do i do this...
LOAD * Inline [
SalesMan,Inv_Num,Amount,Year,Month,Date
Jones,20010312,10,2012,Jan,02/01/2012
Jones,20010312,15,2012,Jan,02/01/2012
Jones,20010313,202,2012,Jan,03/01/2012
Jones,20010313,202,2012,Jan,05/01/2012
Jones,20010314,437,2012,Jan,03/01/2012
Jones,20010314,487,2012,Jan,04/01/2012
Jones,20010315,20,2012,Feb,04/02/2012
Jones,20010316,53,2012,Feb,05/02/2012
Jones,20010317,23,2012,Apr,05/04/2012
Jones,20010317,55,2012,Apr,06/04/2012
Jones,20010317,55,2012,Apr,07/04/2012
Jones,20010317,55,2012,Apr,08/04/2012
Jones,20010317,55,2012,Apr,09/04/2012
];
Regards
Chriss
see the attached file
hope it helps
Hi Mohit,
Thanks for your reply and it works fine...
Thanks