Hi,
I'm trying the summarize the below dataset by Customer number and Max date but having a challenge since the same Customer number can be a different level and needs to summarized at that level
I tried the multi row formula and Summarize tool in Alteryx Designer but I'm not getting the expected results.
See below dataset
Order_Num Date Cust_Num TAT
1 2024-02-12 14022155 0
1 2024-02-13 14022155 1
1 2024-02-14 14022155 1
1 2024-02-14 19016706 0
1 2024-02-15 14022155 1
1 2024-02-16 14022155 1
1 2024-03-10 161180489 23
1 2024-03-27 130G467644 17
Expected dataset
Order_Num Date Cust_Num TAT
1 2024-02-14 14022155 2
1 2024-02-14 19016706 0
1 2024-02-16 14022155 2
1 2024-03-10 161180489 23
1 2024-03-27 130G467644 17
Any help is appreciated.
Regards,
Jimmy
Thanks for the quick response. It worked perfectly.
Much appreciated.
Regards,
Jimmy
User | Count |
---|---|
38 | |
32 | |
8 | |
7 | |
7 |