Alteryx Table

[griseldagomes]

Hello Experts,

Need help in creating 2 pivot tables using the data in the attached file.
Please note, the data is dynamic and some days we may not have data for all age buckets and therefore the table should automatically alter itself to ignore those age buckets.

Attached file contains input data as well as the 2 sample output tables.
Would really appreciate any help in this regard.

Thank You

[binuacs · Accepted solution]

@griseldagomes Sample workflow attached, you can work on the formatting part in the table tool