Question5Replies3463Views×Close popoverVishal Bhardwaj (VishalB8) TCS SME TCS GB View Profile VishalB8 Member since 2013 15 posts TCS Posted: September 29, 2016Last activity: November 16, 2016Posted: 29 Sep 2016 5:28 EDTLast activity: 16 Nov 2016 9:45 EST Closed Need to show total of a column in Report DefinitionDear,I have a requirement from customer where i need to show the total of a column under it in a report definition.COLUMN 1 COLUMN210 2020 30-----------------------------Total 50----------------------------How can we achieve this in PEGA.Regards,Vishal***Updated by Moderator: Vidyaranjan. Removed user added #helpme tag. Apologies for confusion, shouldn't have been an end-user option******Updated by Moderator: Marissa to update categories*** 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: 4 years agoPosted: 29 Sep 2016 8:03 EDT×Close popoverPraveen Kumar Mankala (PraveenMankala) PEGA Principal Technical Solutions Engineer Pegasystems Inc. IN View ProfilePraveenMankala PEGA replied to VishalB8Hello Vishal, You can set the Summarize as Sum for Column2 while in report defination. Please refer attched document for detail information. Regards, Praveen Posted: 4 years agoPosted: 29 Sep 2016 8:53 EDT×Close popoverRajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View Profilenistr PEGA replied to PraveenMankalaIf you need to calculate the sum for both column1 and column2, then use sum for both fields and add the key property (or pzInsKey) to the select fields so that the query groups based on it. Posted: 4 years agoPosted: 14 Oct 2016 15:32 EDT×Close popoverVishal Bhardwaj (VishalB8) TCS SME TCS GB View ProfileVishalB8 TCS replied to VishalB8I want sum of coulmn at the bottom of the column. If i use sum then it will convert the report to summary view. Posted: 4 years agoPosted: 18 Oct 2016 5:46 EDT×Close popoverRajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View Profilenistr PEGA replied to VishalB8You can convert it to a summary report but still show it like a list report using "Do not display group headings". Please refer to the following link - https://pdn.pega.com/sites/pdn.pega.com/files/help_v721/procomhelpmain.htm#rule-/rule-obj-/rule-obj-report-/rule-obj-report-definition/reportviewertab.htm Posted: 4 years agoPosted: 16 Nov 2016 9:45 EST×Close popoverLochana Durgada Vijayakumar (Lochan_DV) MOD Lead Technical Documentation Specialist Pegasystems Inc. IN View ProfileLochan_DV MOD replied to VishalB8Hello All, Thank you for the great discussion. Vishal communicated to us, moderators, that this requirement is dropped for now. I will be closing this thread to future replies and will reopen it (if needed) at a later point in time! Regards, Lochan | Community Moderator | Pegasystems Inc.