Crosstab help needed - need to sum and count

[jdelaguila]

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

FCODE	LISTSEG	COUNT	AR	AZ	CA	CO	CT	FL	GA	IA	IL	KS	MA	MD	MI	MN	MO	NC	NJ	NV	NY	OH	OR	PA	TX	UT	VA	WA
HF	HOUS	101	1	1	8		1	10	1	3	6	2	5	3	10	2	1	2	3	1	9	15	3	4	2	1	2	5
OL	0090	49																49
OL	0219	1																						1
OL	0936	9					9
OL	2090	20																20
OL	3090	18																18
OL	NB04	2			1	1

[jeff_reynolds]

Oops, never mind. missed something in your post. 

[jeff_reynolds · Accepted solution]

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

[deviseetharaman · Accepted solution]

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