Listing the Volume that Changes Everyday

[KamenRider]

HI Guys,

I am working for a workflow that changes everyday since the number of accounts received is not constant. I would like to have this output as shown below

My problem is that the workflow get an error when I inserted the new excel file or data. Please help me how can the workflow accept the changes everday using the output I have. For file 021822, results should look like this:

Please see attached excel files and workflow for your reference.

Thanks and hoping to hear from anyone.

Kamen

[KamenRider]

Hi @atcodedog05  @binuacs  and everyone

I added a sort tool between cross tab and transpose tab which automatically sort the header numbers even they are new figures.

Results

However, the final results is still unsolved. I hope someone would help to below results considering the color coding and chronological orders like as below.

Thanks and looking forward for anyone's ideas.

Kamen

[KamenRider]

Any help or assistance please.

Thanks,

Kamen