I have a very simple sample data, two tables one for amounts and the other for %.
I created a key field to link both together. The allocation simply takes the source amounts with credit value and charge it to different coding as per the data in the percentage table.
I can achieve the results in doing two visuals as per below, but I want to be able to create a table that contains all data for the credits and the debits.
I created two visuals since the credit amounts have to clear the original records and the debits amounts have to follow the percentage table.
Appreciate your help.