I have been using xtuple for some time now, and I want to now find a way to make reports that will show me, for example:
Total sales of a category(or an item) in a year - in dollars and in percentage (can be separate or the same report)
Total sales(dollars) per customer? Percentage of sales per customer?
I did it by hand by seeing sales per category and entering it all into a spreadsheet. But, there must be an easier way:)
There might be other information that might be useful to output from the system, but this is a start.
If you have other ideas of reports that can help analyse my data, that would be cool to see other ideas.