Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Cloe Walker (CloeW938)
IT Solution Service

IT Solution Service
SG
CloeW938 Member since 2018 227 posts
IT Solution Service
Posted: Aug 10, 2020
Last activity: Aug 10, 2020
Posted: 10 Aug 2020 3:31 EDT
Last activity: 10 Aug 2020 23:22 EDT
Closed
Solved

Doubt about Report Definition

Let's say I have below data in a drink table.

001 | orange juice | softdrink

002 | vodka | alcohole

003 | grape juice | softdrink

004 | sprite | soda

005 | coke | soda

I want to get below report.

softdrink | 2

alcohole | 1

soda | 2

Could someone tell me how I can make it?

***Edited by Moderator: Pallavi to update platform capability tags***

 

To see attachments, please log in.
Pega Platform 8.4
Reporting

Accepted Solution

Posted: 4 years ago
Updated: 4 years ago
Posted: 10 Aug 2020 4:01 EDT
Updated: 10 Aug 2020 23:22 EDT
Durai Sankar Ramasubbu (duraisankar)
Capgemini
Senior System Architect
Capgemini
NO

Hi, 

I am considering the values - alcohol, softdrink, etc., are rendered from the property ".DrinkType" 

Create a report with 2 columns with the below configuration.

Column Source       Summarize

.DrinkType                   <Blank>

.DrinkType                    Count

Lets us know if you have any more queries!

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice