Cross Tab for 2 conditions

[krishnagandhi]

Hi, I am trying to utilize the cross tab tool to make a pivot, i know it is possible but i am not able the reproduce the following:

This is the data i have

WorkDate	Emp#	Location
1/1/2020	300122	Onsite
1/1/2020	300122	Offsite
1/1/2020	300320	Onsite
1/1/2020	300320	Other
1/2/2020	300122	Onsite
1/2/2020	300122	Camp
1/2/2020	300320	Onsite
1/2/2020	300320	Offsite
1/2/2020	300122	Onsite
1/2/2020	300122	Other
1/3/2020	300320	Onsite
1/3/2020	300320	Camp
1/3/2020	300122	Onsite
1/3/2020	300122	Offsite
1/3/2020	300320	Onsite
1/3/2020	300320	Other

This is the output i want in alteryx

Thanks,

Krishna

[RolandSchubert · Accepted solution]

Hi @krishnagandhi ,

you could add a value column and then use the Crosstab tool. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland

[Jonathan-Sherman · Accepted solution]

Hi @krishnagandhi,

I think this is what you're trying to achieve?

You can select Sum and Total Column (tick both) in your "Method for Aggregating Values" to get your count and Total Column in the crosstab tool:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Jonathan-Sherman]

Looks as though both @RolandSchubert and I came to exactly the same conclusion!

[RolandSchubert]

@Jonathan-Sherman , I think your solution is a bit more complete, I didn't mention the "Total Column".