Dynamic count and sum

[Pascal_R]

HI Alteryx Community,

Do you have a solution for "dynamic columns" to get sum and count of entries?

Attached you can find an example of a data set. All the headers with a date will change weekly but I always need from those the sum and count of entries calculated.

In yellow highlighted the result I looking for but with having dynamic columns.

Please let me know if you have any ideas.

Thank you very much in advance for your support.

Regards,

Pascal

[Luke_C · Accepted solution]

Hi @Pascal_R 

I'd recommend using a transpose and summarize tool to get the totals and counts, then join back to the data. The transpose should handle any new columns in the future.