I have data:
Customer | Type | Value |
1 | Date | 8/18/2018 |
1 | Amount | 100 |
1 | Date | 8/19/2018 |
1 | Amount | 150 |
3 | Date | 8/20/2018 |
3 | Amount | 200 |
3 | Date | 8/21/2018 |
3 | Amount | 250 |
9 | Date | 8/22/2018 |
9 | Amount | 300 |
9 | Date | 8/23/2018 |
9 | Amount | 350 |
9 | Date | 8/24/2018 |
9 | Amount | 400 |
9 | Date | 8/25/2018 |
9 | Amount | 450 |
And I want it to come out like:
Customer | Date | Amount |
1 | 18-Aug-18 | 100 |
1 | 19-Aug-18 | 150 |
3 | 20-Aug-18 | 200 |
3 | 21-Aug-18 | 250 |
9 | 22-Aug-18 | 300 |
9 | 23-Aug-18 | 350 |
9 | 24-Aug-18 | 400 |
9 | 25-Aug-18 | 450 |
For the life of me I can't get this working properly in Alteryx... any help!
Solved! Go to Solution.
Hi @MOrtez1,
I think you would need to add a RecordID using a Mulitple Row Formula and Group by the RecordID and Customer Field inside your Cross Tab tool: