How to subtotal in People Soft query manager?

Views: 388

Reply to This

Replies to This Discussion

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 (captkristen899@gmail.com)

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.

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2017   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service