Listing the Volume that Changes Everyday

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

Volume Breakdown_021722.xlsx

Volume Breakdown_021822.xlsx

Volume Breakdown.yxmd

Workflow

Error Message

Common Use Cases

Accepted answers

All comments

ChrisTX

Here are a few related posts for a dynamic summarize:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Adding-up-columns-for-sum/m-p/381053#M69784

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Unknown-Select-Feature-w-Summarize-Tool/m-p/327371

Chris

atcodedog05

Hi @KamenRider

Instead of summarize tool use transpose and crosstab combination to summarize. This will always consider the columns dynamically.

Hope this helps : )

Volume Breakdown.yxmd

binu_acs

@KamenRider may be you can add a Table tool for the formatting in the workflow provided by @atcodedog05

Volume Breakdown (1).yxmd

KamenRider

Hi @binu_acs @atcodedog05

Thanks for the response. One problem I have is that when I run a new report especially if the queue days is new, the field Total no longer position at the end just like the sample screenshot below: Additionally, the new added figure appears on the last columns. Is there a way we could always put the total at the end even though new figures were added?

Another configuration to add is that when queue days is 5 and more, the figure color is red and 0 to 4 just black color will do.

Hoping for your response on this matter.

Thanks,

Kamen

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703