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.
SOLVED

Crosstab help needed - need to sum and count

jdelaguila
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!

Javier

 

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

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

Oops, never mind. missed something in your post. 

jeff_reynolds
10 - Fireball

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

deviseetharaman
11 - Bolide

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

Labels