Replies to This Discussion

Permalink Reply by Robin Smith on March 14, 2013 at 10:41am

Are you looking to print a list and then show a sub total or are you trying to list a bunch of fields and then display the sub-total for that 

You can't do the first one directly in Query. You can take the data into BI Publisher and do it from there. If you want the second one, you can create a sum on the field that you want the total for and group by the other fields 

select field1,field2 etc..., sum(field_x) from table where group by field1,field2 etc

• ▶ Reply

Permalink Reply by kristen on July 9, 2017 at 1:52pm

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

• ▶ Reply

Permalink Reply by Suzanna Picazo Hardin on August 16, 2017 at 7:39am

You can create sub-totals and grand-totals by using unions in your query.  first level is your list.  next levels use sum to get your sub totals or grand totals.  I have written this type query and it works well for reports not requiring a lot of tables.

• ▶ Reply