Product Grid report on a single row based on data

Product Grid report on a single row based on data

hi,

I'm using Zoho Creator to manage our food bank.

We are required to provide a report for any movement of the warehouse in a specific format.

Consider we have Porduct A (100) and Prouct B (200)  incoming on Date A 

The requirement  is to have a report built in this way


DATE --------  PRODUCT A - QUANTITY -- PRODUCT B QUANTITY

DATE A -- ------------------------1000 ---------------------------200

Is it possible using the reports?

In the database for each product added I have the dte and the quantity

Thank you
GIovanni