Creating a Pivot Table

[Gaetano_B]

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

[wwatson]

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.

[AngelosPachis]

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

[AngelosPachis · Accepted solution]

or maybe this version 

I think that's as close as I can get