I am currently attempting to display a % in a chart on a users dashboard. I need to take the sum of one column and divide it by the sum of another column. I have created a sub-report to give column a and b a Sum summarize selection. When dividing the sub reports 2 columns on the main report, there is no summarize option that yields correct data. Is there a way to display a chart without having to select one of the generic summarize selections?
Is this just not possible in Pega? This is a simple task in Excel but I cannot see a way to do this in Pega.
In Pega, whenever you want to add a chart to a report definition at least one of the column should contain any of the "Summarize" option available by OOTB. Even though the sub report has the summarized column values the main report should contain atleast one aggregate column for enabling chart feature.
"You must save this report with at least one aggregated numeric column before defining a chart"