Hi there, happy Friday.
I'd like to create a pivot through Alteryx just like in excel.
I'm attaching the data sample, would you say I should you cross tab to get the exact same pivot?
many thanks,
Gaetano
Solved! Go to Solution.
You can pivot data using the Cross Tab tool.
The result will be a flat table. You will not be able to create the drill through functionality available in an Excel pivot though.
Hi @Gaetano_B ,
@wwatson is right here, it will be a bit difficult to imitate what Pivot does in Excel. However, I have created a workflow the output of which looks like your Pivot table.
Hope that helps somehow.
Regards,
Angelos