Cross Table - Difference Over Function

Hello,

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

 

Kai

Attachments

AttachmentSize
Binary Data crosstable_-_tabelle1.dxp425.29 KB
Login