Hello.
I have a report which shows me invoices with details and the total of each invoice. I am grouping by invoice number as per below example
Invoice # Item Position Invoice Total
(Detail) 1 1 100
1 2 100
GF1
(Detail) 2 1 150
2 2 150
What I would like to achieve here is to Subtotal on each group the Invoice Total, however I cannot sum Invoice Total as it would be incorrect. Invoice 1 Total is 100 and Invoice 2 Total is 150, however both show twice on details section as each invoice has 2 items listed.
Below is the output I would like to achieve.
I think a formula would be best as then I could use the output values for further formulas
Invoice # Item Position Invoice Total
(Detail) 1 1 100
1 2 100
GF1 SubTotal 100
(Detail) 2 1 150
2 2 150
SubTotal 150
Total 250
Regards,
Fraser