I have the following output data, but I need it to be reflected as one record, and not four, with the Grand Total.
I can de-select the Trans Date no problem, but I need to have the data consolidated into one record.
Current Records:
Item | Description | UOM | Dept Name | Trans Date | SUN | MON | TUE | WED | THU | FRI | SAT | Grand Total |
1203 | COVER SHOE XTRC SMS XL 3 PLY | BX | GENERAL SURGERY | 5/26/2020 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 3 |
1203 | COVER SHOE XTRC SMS XL 3 PLY | BX | GENERAL SURGERY | 5/27/2020 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 4 |
1203 | COVER SHOE XTRC SMS XL 3 PLY | BX | GENERAL SURGERY | 5/28/2020 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 |
1203 | COVER SHOE XTRC SMS XL 3 PLY | BX | GENERAL SURGERY | 5/29/2020 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |
Suggested Record:
Item | Description | UOM | Dept Name | SUN | MON | TUE | WED | THU | FRI | SAT | Grand Total |
1203 | COVER SHOE XTRC SMS XL 3 PLY | BX | GENERAL SURGERY | 0 | 0 | 3 | 4 | 6 | 1 | 0 | 14 |
Can anyone give me some ideas on how I can do this?
Very much appreciated !!
Kiri
Solved! Go to Solution.
Hi @KSassone I mocked up a workflow let me know what you think?
Thank you @JosephSerpis and @jeff_reynolds ! I knew there was an Alteryx solution - am so embedded in this project that I couldn't see for the trees !