Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Amount in the Ageing bracket and total amount per row

SH_94
11 - Bolide

Hi Community , 

 

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

Jcsh_66_0-1617009884942.png

 

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:

Jcsh_66_0-1617011138941.png

Jcsh_66_1-1617011168819.png

 

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

 

 

 

1 REPLY 1
AkimasaKajitani
17 - Castor
17 - Castor

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.

AkimasaKajitani_0-1617014000861.png

Please see the uploaded file.

Labels