Need to show total of a column in Report Definition
Dear,
I have a requirement from customer where i need to show the total of a column under it in a report definition.
COLUMN 1 COLUMN2
10 20
20 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***
Pegasystems Inc.
IN
Hello Vishal,
You can set the Summarize as Sum for Column2 while in report defination. Please refer attched document for detail information.
Regards,
Praveen
Pegasystems
IN
If 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.
Pegasystems
IN
You 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://community.pega.com/sites/default/files/help_v721/procomhelpmain.htm
Pegasystems Inc.
IN
Hello 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.