Client Overview should contain sub summary of different products bought according to category
I am stuck at developing the database.
I have the client overview. On this client overview, I have a portal with the whole history of products bought according to category and the final amount for this service.
Now I would like to have a calculation to show me the total of each category.
For example, the client ordered in total products for 5,000 USD. However he ordered products A of 1,000 USD, products B of 2,000 USD and products C of 2,000 USD.
I am able to get this information on the report file. Is there also a possibility to get this information according to the categories on my client overview?
I am using Filemaker Pro 12.
thanks a lot in advance for your help.