Amount in the Ageing bracket and total amount per row

SH_94

Hi Community , 

Previously, i have built the workflow regarding to the ageing bracket based on the number of days as per screenshot below.

However, the amount in the ageing bracket seem to be incorrect maybe due to the workflow that i had done.Basically i would like to produce the result as per result screenshot 1 and 2 below:

May i know how can i edit in the workflow ? I had attached my workflow below for your reference.

Back up AR 4.2.yxzp

AkimasaKajitani

Hi @SH_94 

You group at CrossTab tool without distinguishing each records. So the result is what you are not looking for.

I added the RecordID tool and distinguish the each records at grouping of CrossTab and Join tool.

Please see the uploaded file.

Back up AR 4.2_AK.yxzp