Thanks for your response.
Intelligence Beta gives reports with one dimension, e.g sales by variant,
sales by customer.
We want to look at sales by product by customer and do comparisons of sales
trends for products across our different customers. For that we need sales
data with two dimensions. Hence the request for a CSV.
Fields required for Invoice Detail Report:
Date of Last Shipment
Bill To Country
Ship to Name
Ship To Country
Invoice line total value
- include custom lines e.g. shipping
- provide a date filter. Initially we will want an “all history” report,
then we will take data weekly.
- this report is not very useful on screen: it is the source data for an
Excel Pivot Table. We would use it in Excel, so a CSV is best.
Am I the only person who wants to get data out in CSV format? I would be
surprised if so....
Let me know your thoughts on providing this facility
Labor & Birth Pools - Safety by Design
Portable Birth Pools at www.birthpoolinabox.com