Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Creating tables/pivots in Alteryx

HannahSwain
7 - Meteor

Good afternoon,

 

I am hoping for some assistance please.

 

I currently have a data set which is similar to the following:

 

DataComputerDate
AYesJan
BNoJan
CYesApr
DYesMar
ENoMar
FNoFeb

 

Ideally, I would like to create a formula or pivot in alteryx which shows the data as following:

 

 JanFebMarAprMayJune
Yes1011  
No1110  
Total      
YTD Total      
% Yes YTD      

 

Any assistance will be greatly appreciated!

 

Many thanks,

 

Hannah

 

1 REPLY 1
squigley17
6 - Meteoroid

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

Labels