Creating tables/pivots in Alteryx

[HannahSwain]

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

[squigley17 · Accepted solution]

Hey I believe this should do what you are asking. Good Luck!