View with data aggregated by date and another column

[SHAR8F]

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.

[Lynn]

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.

[SHAR8F]

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.

[Chris_Jeal]

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

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

REF_ROWS()

Gather related rows from table or slice