ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Crosstab help needed - need to sum and count

8 - Asteroid

Hello everyone!


I'm new to building Cross Tabs and i'm trying to build the below using the data attached - see attached file Crosstab_Problem.yxmd.


The problem i'm having is building the COUNT field which sums up the FCODE and LISTSEG field, and than the STATE field needs its each individual count. 

So basically FCODE, LISTSEG and COUNT would be my Rows and ISTATE would be my Column.


Any help would be greatly appreciated. Thanks!



This is what i'm trying to get with the Workflow attached. No

HFHOUS101118 1101362531021231915342125
OL009049               49          
OL02191                     1    
OL09369    9                     
OL209020               20          
OL309018               18          
OLNB042  11                      
10 - Fireball

Oops, never mind. missed something in your post. 

10 - Fireball

I think the attached workflow does what you're looking for. 

11 - Bolide

Updated @jeff_reynolds's Workflow. Removed the Select Tool and Replaced it with Dynamic Rename Tool.