Hi Team,
I am having a total of 6 six percentage columns in list report. Out of which, for four columns need to display the subtotal & total summary at aggregate level.
For other two columns, need to calculate the percentage on subtotal & total using different logic.
In order to achieve this, I used the join query to fetch the expected data in subtotal & total.
For displaying detail data in each row for that 6 percentage columns is fetching from single base query only. For calculating subtotal for two columns alone, I used the separate SQL embedded query.
Issue here is, if I fetch aggregate summary for these 4 columns from single base query, then subtotal & total is displaying the expected result but if I refer the resultant join query & applying aggregate function on subtotal & total summary, then aggregate summary is not working as expected.
Please help me with this issue.