Question5Replies3390Views VishalB8 Member since 2013 15 posts TCS Posted: 4 years agoLast activity: 3 years 11 months ago 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 agoPraveenMankala 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 agonistr 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 agoVishalB8 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 agonistr 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… Posted: 3 years agoLochan_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.