View with data aggregated by date and another column

Hello,
I’m tracking daily sales for various shops and my data collection table looks like this:

I need to present a view that looks like this:

i.e, showing total sales and total units for each shop, on a single date. Please advise on how I can go about this.

Thanks.

Hi @SHAR8F
Have you tried just running a query on the first sheet to your second sheet? Not sure if this is the best or recommended solution.

2 Likes

Hello @Lynn

Thanks for the reply. Let me try out the query function in Google sheets and see how that works out. I will update accordingly.

Thanks again.

2 Likes

Hi,
Refer to the appsheet documentation it will help no end.

1 Like