Hello All -
We would like to have a query that shows us monthly sales by geography (US State).
However, using the Bill To Address or the Ship To Address is a problem for us -- I won't get into the details but it doesn't serve our purposes very well.
Instead, we would like the location to be referenced from our account number. The first two characters of a BP's account number represents their state.
So, first step would be to consolidate sales for all BP's that share the same first two letters in their account number. This should, in theory, give us total sales for a particular state. Then, we would want to see a listing of that state's sales by month. So, result would be something like this:
Jan Feb Mar etc.
Can anyone help with this?