Question5Replies3027Views JohnPaulRaja,C Member since 2011 246 posts Cognizant Posted: 3 years agoLast activity: 3 years 1 month ago Closed How to add sum of aggregate function in Report definition without subreport or JoinHi,How to add sum of aggregate function in Report definition without subreport or Join Pega version 7.2.1#Reporting Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agoShruthiMukka_GCS PEGA replied to JohnPaulRaja,CA sub-report at least is necessary to get the sum of an aggregate function. So, I don't see any other way to do the sum of aggregate without sub-report or join. Posted: 3 years agocherb PEGA replied to JohnPaulRaja,CHi John_paul_raja, In the report definition, we have fx button next to column source. Below is the screen print Click on the fx utton to launch calculation builder. Press down arrow to load the different functions which satisfies your requirement. If you are looking something different or my understanding is not correction then I would request you to elaborate the requirement Please feel free to reply your thoughts Thank you Posted: 3 years agorodrg PEGA replied to JohnPaulRaja,CHello, There is no direct way to achieve your requirement. You need to create sub-reports. Thanks, Gisela Posted: 3 years agoJohnPaulRaja,C Cognizant replied to rodrgIn my requirement if I use sub report it is not working as expected. Posted: 3 years agoShruthiMukka_GCS PEGA replied to JohnPaulRaja,CYou may create an SR if sub report used is not working as expected.