Summary table from grid and summary applications

Hi guys,

I’m try to build an application that manages personal income tax collection. I have a grid application that shows payroll of employees grouped by organization with a calculated fields for tax payable.In other words, one record per employee. Another grid application shows income tax remittance by organizations on behalf of their employees. Here, we have one record per organization.

Now, I’d like to create a summary table that shows income net tax payable as the difference between sum of tax payable by employees per organization(aggregated over a period) and the actual tax remitted over same period of time.

Kindly help with a solution in scriptcase.