Cross Table - Difference Over Function


ich have a hugs problem to solve. I have a data table and i want to get a cross table from it. I attaching a file, where you can see and following my minds.


  1. I want to the the difference between the month. If the previous month is not in the Data Table, then must be the difference the starting amount, if the previous mounth in the table, then must be the difference. The Over-Function/Difference need for Paid and Recovered.

I had mark the problem with a screenshot in the file. Hope I can explain clearly.

Hope, anyone can help me to solve it.

Kind regards and THX




Binary Data crosstable_-_tabelle1.dxp425.29 KB