Query Manager Subtotal - myPeopleSoft2024-03-28T17:51:36Zhttp://www.mypeoplesoft.com/forum/topics/query-manager-subtotal?commentId=6576243%3AComment%3A49311&x=1&feed=yes&xn_auth=noYou can create sub-totals and…tag:www.mypeoplesoft.com,2017-08-16:6576243:Comment:493112017-08-16T14:39:01.624ZSuzanna Picazo Hardinhttp://www.mypeoplesoft.com/profile/SuzannaPicazoHardin
<p>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.</p>
<p>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.</p> it's a pleasure to meet you.…tag:www.mypeoplesoft.com,2017-07-09:6576243:Comment:481882017-07-09T20:52:37.798Zkristenhttp://www.mypeoplesoft.com/profile/kristen
<p>it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.<br/>Please write me on my email (captkristen899@gmail.com)<br/><br/></p>
<p>it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.<br/>Please write me on my email (captkristen899@gmail.com)<br/><br/></p> Are you looking to print a li…tag:www.mypeoplesoft.com,2013-03-14:6576243:Comment:94402013-03-14T17:41:23.431ZRobin Smithhttp://www.mypeoplesoft.com/profile/RobinSmith
<p><span style="text-transform: none; background-color: #ffffff; text-indent: 0px; display: inline !important; font: 14px/21px arial; white-space: normal; float: none; letter-spacing: normal; color: #000000; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">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<span class="Apple-converted-space"> …</span></span></p>
<p><span style="text-transform: none; background-color: #ffffff; text-indent: 0px; display: inline !important; font: 14px/21px arial; white-space: normal; float: none; letter-spacing: normal; color: #000000; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">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<span class="Apple-converted-space"> </span></span><br style="text-transform: none; background-color: #ffffff; text-indent: 0px; font: 14px/21px arial; white-space: normal; letter-spacing: normal; color: #000000; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;"/><br style="text-transform: none; background-color: #ffffff; text-indent: 0px; font: 14px/21px arial; white-space: normal; letter-spacing: normal; color: #000000; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;"/><span style="text-transform: none; background-color: #ffffff; text-indent: 0px; display: inline !important; font: 14px/21px arial; white-space: normal; float: none; letter-spacing: normal; color: #000000; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">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<span class="Apple-converted-space"> </span></span><br style="text-transform: none; background-color: #ffffff; text-indent: 0px; font: 14px/21px arial; white-space: normal; letter-spacing: normal; color: #000000; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;"/><br style="text-transform: none; background-color: #ffffff; text-indent: 0px; font: 14px/21px arial; white-space: normal; letter-spacing: normal; color: #000000; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;"/><span style="text-transform: none; background-color: #ffffff; text-indent: 0px; display: inline !important; font: 14px/21px arial; white-space: normal; float: none; letter-spacing: normal; color: #000000; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">select field1,field2 etc..., sum(field_x) from table where <criteria> group by field1,field2 etc</span></p>