CUSTOMIZED SORT

[samxhander09]

Hi Community. Im trying to do an exercise but im stuck on this particular item. my data looks like the below

The formula that was given to us was to Subtract Amt3 of FileName 123 Consolidated_Booking_Activity to 123 Consolidated Booking Activity Dec 21 and the value from that will be added to Amt3 of 123 Consolidated Booking Activity Dec 22. Looks like the below

(-7,375,721.56) - (-5,144,452.91) + (-3,665,087.15)

Question is; hoe can i arrange the data to make it so?

[gautiergodard · Accepted solution]

Hey @samxhander09 

Here is one way to do it.

[samxhander09]

@gautiergodard thanks buddy! works like magic!