Best way to to merge pivots into one report
Hi, I am evaluating zoho reports and can't work out if the following is possible.
I would like to merge two pivot tables together to form a sales history and current inventory report.
I think this can be hopefully be accomplished with query tables.
Table one contains the sales data and the second table contains the inventory.
The sales data needs to be pivotted to create a monthly total sales report. I then want to tack on the end of the table the inventory for each product.
An example is shown in the attachment.
Is this report possible?