Good afternoon,
I am hoping for some assistance please.
I currently have a data set which is similar to the following:
Data | Computer | Date |
A | Yes | Jan |
B | No | Jan |
C | Yes | Apr |
D | Yes | Mar |
E | No | Mar |
F | No | Feb |
Ideally, I would like to create a formula or pivot in alteryx which shows the data as following:
Jan | Feb | Mar | Apr | May | June | |
Yes | 1 | 0 | 1 | 1 | ||
No | 1 | 1 | 1 | 0 | ||
Total | ||||||
YTD Total | ||||||
% Yes YTD |
Any assistance will be greatly appreciated!
Many thanks,
Hannah
Solved! Go to Solution.