I have a database with 3200 rows of location data that I need to categorize into three categories within each territory based on sales. Seems simple, until.....
The problem is I need to categorize by sales and number of sites within the territory. Try to explain,
A territory could have between 50 and 150 accounts.
I need to find the top %25 of sites within each territory based on sales and insert an "A" beside them.
Clear as mud right
I dont even know where to start on this one. Maybe its way to complex but I have been bouncing this around for a few months.
This will be a challenge I think.
Anyone up for a challenge? I really dont like to ask someone to do the work for me, but this is way over my capability!
Thanks again to all....
</IMG></IMG></IMG></IMG>