Using Excel, I have query(using an ODBC connection) of all customer order
detail over a two year time period. The detail for each customer is
different in that some customer have multiple orders, and the amount of
individual sales parts they order may be 1 or 100. My query gathers detail
by order line item. We were able to provide management with comparative
sales data.
Now that we have shown this report to management, they want three things
that I'm unsure how to provide. 1) Customers that are new in the current
year2) customers that had orders in both years, 3)customers that ordered in
the prior year that have no cy orders.
Using the pivot table funtion, is there any way to filter data, so that if
both years are >0, then show those customers? To show if the difference
between the data is positive or negative, only those customers, respectively?
Remember that the line item detail in my query only shows one sales part,
for one year's activity per row.
Thank you.
Bookmarks