I am trying to create a customized report in RRDI by pulling RTC data. By joining few queries, I am able get the data in the format below:

In the above table, customer name and amount are the custom attributes and workitem state is a inbuilt attribute in RTC. These states are well defined in the workflow.

Based on the above data I want to generate a report:

Formulae used for the figures in the respective columns are as follows:

Total Fund released = Total of Amount column based on the customer name column.

Total Fund acknowledged = Total of Amount column based on workitem state and customer name column.

Fund acknowledged but not released = Total Fund released - Total fund acknowledged.

I want to generate this report (2nd table) automatically based on the data in (1st table).