Hello,
I have a new table created called Sales Analysis, this records all sales activity within the system. I need to create a report that has the following Data Items:
Customer
Item Category
Item
The Item Category is on both the Item Category Table and Item Card, but of course not on the Customer so how can I create the report so that it iterates in the above way reporting all items sold by category by customer.
Thanks