I have a data set (Sheet1 tab) and an example pivot (Pivot tab) that I am trying to create in Alteryx. I need Completion Date down in rows and the Frequency across the top with Count and ErrorMessage Ct as well. Is it possible to do this in Alteryx, everything I am trying is not working. Any help would be appreciated.
DATASET:
| FREQUENCYSTATUS | COMPLETIONDATETIME | Count | Sum_ERRORMESSAGE_CT |
| Daily | 12/1/2024 | 2 | 1 |
| Daily | 12/2/2024 | 2 | 0 |
| Daily | 12/3/2024 | 2 | 0 |
| Daily | 12/4/2024 | 2 | 0 |
| Daily | 12/5/2024 | 2 | 0 |
| Daily | 12/6/2024 | 2 | 0 |
| Daily | 12/7/2024 | 2 | 1 |
| Daily | 12/9/2024 | 3 | 1 |
| Daily | 12/10/2024 | 2 | 0 |
| Daily | 12/11/2024 | 2 | 0 |
| Monthly | 12/1/2024 | 1 | 1 |
| Monthly | 12/2/2024 | 1 | 0 |
| Weekly | 12/2/2024 | 24 | 8 |
| Weekly | 12/3/2024 | 18 | 0 |
| Weekly | 12/4/2024 | 24 | 8 |
| Weekly | 12/5/2024 | 39 | 24 |
| Weekly | 12/6/2024 | 40 | 32 |
| Weekly | 12/9/2024 | 49 | 32 |
| Weekly | 12/10/2024 | 68 | 50 |
| Weekly | 12/11/2024 | 57 | 50 |
| Weekly | 12/12/2024 | 2 | 0 |
PIVOT:
| | Column Labels | | | | | |
| | Daily | | Monthly | | Weekly | |
| CompletionDate | Sum of Count | Sum of Sum_ERRORMESSAGE_CT | Sum of Count | Sum of Sum_ERRORMESSAGE_CT | Sum of Count | Sum of Sum_ERRORMESSAGE_CT |
| 12/1/2024 | 2 | 1 | 1 | 1 | | |
| 12/2/2024 | 2 | 0 | 1 | 0 | 24 | 8 |
| 12/3/2024 | 2 | 0 | | | 18 | 0 |
| 12/4/2024 | 2 | 0 | | | 24 | 8 |
| 12/5/2024 | 2 | 0 | | | 39 | 24 |
| 12/6/2024 | 2 | 0 | | | 40 | 32 |
| 12/7/2024 | 2 | 1 | | | | |
| 12/9/2024 | 3 | 1 | | | 49 | 32 |
| 12/10/2024 | 2 | 0 | | | 68 | 50 |
| 12/11/2024 | 2 | 0 | | | 57 | 50 |
| 12/12/2024 | | | | | 2 | 0 |
| Grand Total | 21 | 3 | 2 | 1 | 321 | 204 |
