Cross Tab for 2 conditions

Question

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

WorkDateEmp# Location1/1/2020300122Onsite1/1/2020300122Offsite1/1/2020300320Onsite1/1/2020300320Other1/2/2020300122Onsite1/2/2020300122Camp1/2/2020300320Onsite1/2/2020300320Offsite1/2/2020300122Onsite1/2/2020300122Other1/3/2020300320Onsite1/3/2020300320Camp1/3/2020300122Onsite1/3/2020300122Offsite1/3/2020300320Onsite1/3/2020300320Other

This is the output i want in alteryx

Thanks,

Krishna

RolandSchubert · Accepted Answer

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 Answer

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