ICETOOL
Posted: Tue Apr 23, 2013 10:04 pm
Hi Guys/Girls,
I,m looking for some help to steer me in the right direction.
I have to generate a report to show the best perming shop for each month summed over a number of years ?
I am able to carry out the initial sort and from that determine overall sales for every month and every year?
But what I need is the overall best selling location per month over the number of years?
I have tried SELECT UNIQUE and OCCUR without much success
Any help would be appreciated
ps; be gentle I,m a NEWBIE
I,m looking for some help to steer me in the right direction.
I have to generate a report to show the best perming shop for each month summed over a number of years ?
I am able to carry out the initial sort and from that determine overall sales for every month and every year?
But what I need is the overall best selling location per month over the number of years?
I have tried SELECT UNIQUE and OCCUR without much success
Any help would be appreciated
ps; be gentle I,m a NEWBIE