In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Creating a Pivot Table

Gaetano_B
8 - Asteroid

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

3 REPLIES 3
wwatson
12 - Quasar

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.

wwatson_0-1604076010475.png

 

AngelosPachis
16 - Nebula

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.

 

Screenshot 2020-10-30 164532.jpg

 

Hope that helps somehow.

 

Regards,

 

Angelos

AngelosPachis
16 - Nebula

or maybe this version 

 

Screenshot 2020-10-30 170054.jpg

 

I think that's as close as I can get

Labels
Top Solution Authors