Not standard group table
Hi all
I want to have a table which groups all supplier invoices. Each row is to be a sum of all invoices due on that date and by each specific supplier.
Eg:
Row1: SupplierA | 12th Jan | 16 invoices | £20,456
Row2: SupplierB | 12th Jan | 1 invoices | £7,456
Row3: SupplierC | 15th Jan | 3 invoices | £2,456
I can’t find out how to get this kind of query on to a table in a panel.
Thanks
I want to have a table which groups all supplier invoices. Each row is to be a sum of all invoices due on that date and by each specific supplier.
Eg:
Row1: SupplierA | 12th Jan | 16 invoices | £20,456
Row2: SupplierB | 12th Jan | 1 invoices | £7,456
Row3: SupplierC | 15th Jan | 3 invoices | £2,456
I can’t find out how to get this kind of query on to a table in a panel.
Thanks
