Organize table like cross tab but more like a countif

[flipperdm]

Hi,

I have data that has been prepared to help the user quickly determine appointments that are non-compliant.  I would like to summarize this data into a condensed table but cross-tab doesn't quite work.  Here is a small capture of my data...

Appt Info	Out_Type	MABD Compliance (Carrier)	MRBD Compliance (Operations)
Appt#: 6071977 Ordered: 48	Regular Item Outed, In Yard	Late	Past Due
Appt#: 6026227 Ordered: 144	Regular Item Outed, In Yard	Late	Past Due
Appt#: 6027948 Ordered: 132	Top Item Outed, In Yard	Late	Past Due
Appt#: 6023461 Ordered: 32	Top Item Outed, In Yard	Late	Past Due
Appt#: 6017219 Ordered: 216	Top Item Outed, In Yard	On Time	Past Due
Appt#: 6025046 Ordered: 50	Top Item Outed, In Yard	Late	Past Due
Appt#: 6023461 Ordered: 80	Top Item Outed, In Yard	Late	Current
Appt#: 6023461 Ordered: 320	Top Item Outed, In Yard	Late	Current
Appt#: 6023461 Ordered: 32	Top Item Outed, In Yard	Late	Current

And here's how I want to summarize...

	MABD On Time	MABD Late	MRBD Current	MRBD Past Due
Regular Items Outed, In Yard		2		2
Top Items Outed, In Yard	1	6	3	4

Any ideas on how I can create this summary within Alteryx?

Mark

[MSalvage]

@flipperdm,

The attached workflow should get you most of the way there. may have to rename some columns.

Best,

MSalvage

[flipperdm]

Hi MSalvage,

Unfortunately, I'm running version 10.5 and I can't update until my company updates the file in our software download area.  Would you have a screen capture or can you save in a previous version?

Mark

[MSalvage · Accepted solution]

@flipperdm,

Snip below let me know if it doesn't make sense.

Best,

MSalvage

[flipperdm]

Works!  Thanks MSalvage.