PeopleSoft Community Network
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 <criteria> group by field1,field2 etc
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 (firstname.lastname@example.org)
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.