I have a report based on a query. I am trying to get a sum of the field "Truck Gross" (a calculated field created by the query, i.e. not found in the underlying table) by date.
Once I have the total by date I want to create another total that sums the date totals.
Is this possible and if so how do I accomplish this?
[Solved] Group Total in Report
[Solved] Group Total in Report
Last edited by Hagar Delest on Wed Nov 21, 2012 10:15 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
LibreOffice3 3.5.7.2 Build ID: 350m1 (Build:2) running on Linux Fedora 17
Re: Group Total in Report
You can do it in the query, but that is rather complex for two sums over different groups. But you can do it also in oracle/sun report builder. See here. Note that you have to read the data in the correct order and have the report create groups at the right level (by date).
It's Microsoft marketing that tells you computers are qualified for non-technicians
W11 22H2 (build 22621), LO 7.4.2.3(x64)
W11 22H2 (build 22621), LO 7.4.2.3(x64)
Re: Group Total in Report
I actually figured it out before I was able to get back here. I just used the Accumulation(sp) function and it worked like a charm.
LibreOffice3 3.5.7.2 Build ID: 350m1 (Build:2) running on Linux Fedora 17