Displaying an accurate percentage in a chart
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.