I have a straight table chart with the following fields: CustomerName, Invoicenumber, InvoiceLineNo, LineTotal. Each invoice has several lines
I would like to display on the first line of each invoice (InvoiceLineNo=0) the amount of the entire invoice - something simular to a subtotal, but as an expression field in the straight table
What expression should I use? If it was just SQL, I would do a subquery to get that info. I looked into SET Analysis in the reference but was unable to find the proper way to do it.
