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()))