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
