How to write a group by expression

[VincyJelsingh]

Hello,

I have a table that consists of various bookings such as groups and one to one. I have created a slice that filters only the group bookings from this main table for the current day. This Slice is 'Group Current Day'. This slice contains all group bookings of various services such as - physiotherapy, massage, yoga etc. I would like to sum all the different modes of payments such as cash, EFTPOS in two different fields for the respective service. 

Ideally a query as below:

select sum(cash) as TotalCash, sum(EFTPOS) as TotalEFTPOS from 'Group Current Day' group by Service name;

I am unsure how to write this query in Appsheet as I do not know how to group it

SUM(SELECT(Group Current Day[Cash],[Date] = TODAY()))

[Steve]

Where do you intend to store the resulting computed values?

[VincyJelsingh]

I would like to store it in another table so that this table could be referenced for another graph view

[Steve]

Ideally, you'd have a Services table. In that table would have a virtual column that would compute the needed sums for each service.