Question4Replies42Views AbhishekS6618 Member since 2020 4 posts Genpact Posted: 2 months agoLast activity: 2 months 3 weeks ago Count of Combination of Grouped ColumnsHi All,In Report Definition, how can we can get the count of grouped columns.lets say there are 4 columns - Month,a,b and c.How can i get the count of each combination of column a, b and c like shown in the table below: MonthABCCountJulyTransportRoadCar5JulyTransportAirPlane3AugustTransportRoadCar3AugustTravelRoadBus2 ***Edited by Moderator: Pallavi to update platform capability tags*** Pega Platform Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Posted: 2 months agoUpdated: 2 months agoJohnPaulRaja,C Cognizant replied to AbhishekS6618Hi,1.Create Report Definition with Count aggregate method2. Call the report definition from Datapage 3. Connect data page with UI table, only summary column property is different - .pySummaryCount(1), remaining are direct mapping. Sample tableReport definitionData pageTable - count column property mapping Final Posted: 2 months agoAbhishekS6618 Genpact replied to JohnPaulRaja,CHi,Thank you very much. I tried the above approach but the count I get is exceptionally high and doesnt matches with the data in the database.Count in n the database is less than 100, however I am getting results in thousands and lakhs.Please let me know if I am missing something, any configuration in Report Definition?Please find the screenshot below. Posted: 2 months agoJohnPaulRaja,C Cognizant replied to AbhishekS6618Hi Abhishek,1. Trace the report definition query from the tracer and validate how the query is formed, run the query from your sql developer2. I do see you are using function getmonthsfromdate, is it works fine?3. Just to identify the root cause, remove the function getmonthsfromdate column, add aggregate method in some other column and validate it Posted: 2 months agoAbhishekS6618 Genpact replied to JohnPaulRaja,CHi,Thanks for your reply.Please find my answers below:1. Will try this.2. Yes, it works fine. It is created to get month's name (as in "January" from Date 01-01-2020)3. Tried this but still got exceptional count.