getting subtotals in a graphic object

[JACKNIEKERK]

hello,

Having a graphic connected to 1 tabel with invoices lines

in  one invoice the key is ordernummer, unique.

Thus could be in tabel like

ordernr: 1 amount qty date customer id line 1
ordernr: 1 amount qty date customer id line 2
ordernr: 1 amount qty date customer id line 3
ordernr: 1 amount qty date customer id line 4
ordernr: 2 amount qty date customer id line 1
ordernr: 2 amount qty date customer id line 2
ordernr: 2 amount qty date customer id line 3
ordernr: 2 amount qty date customer id line 4
ordernr: 3 amount qty date customer id line 1
ordernr: 3 amount qty date customer id line 2
ordernr: 3 amount qty date customer id line 3
ordernr: 3 amount qty date customer id line 4

In graphic now i see orders by number but every single line

how to show 1 line with total per ordernr?

[Brett_Bleess · Accepted solution]

QVW file would be most helpful on this one, if you want to potentially get some responses, I do not believe there is enough information provided for anyone to be able to offer much otherwise.  Inputs and outputs are very helpful as far as guiding folks, so at a minimum some sample data clearly denoted as to column names etc. and expected output would be best if you cannot attach QVW file.

Regards,
Brett