I have asked this question earlier but haven't got any reply. Could someone reply.
I have customer reward points data. I have 2 tables.
1. CumulativeCredit -> Customer credited points and cumulative total
2. CumulativeDebit -> Customer debited points and cumulative total
From these 2 tables, I need to generate resultset to show how the customer points are debited. I mean the points debited are to be distributed as per they earned.
See attached spreadsheet for sample data and expected resultset.
I am totally mad to solve this.
Could someone have an eye on this and suggest how to achieve the result?