Group Order numbers based on unique entity and its weekly requirement

[uvdurai90]

Dear Friends

I need to group Order numbers (1, 2, 3 etc.) based on unique entity (A, B, C etc.) and it's weekly requirement.. I have attached the excel version of sample data and desired result

Please help me with Alteryx workflow

Thanks & Regards

Velladurai

[Thableaus · Accepted solution]

Hi @uvdurai90 

See if this would work.

Cheers,

[uvdurai90]

Thank you so much @Thableaus 👌.. It really worked and met my requirement 😊