Alteryx Designer Desktop Discussions

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

Pivot table with Multiple Columns

Athilingam_S
7 - Meteor

Experts

 

I have done in excel pivot and get the expected  result but i am struck in alteryx to get the same results

could you please help me on this if anyway to get same results

 

I have attached with data and excel pivot

 

Excel Pivot

Athilingam_S_0-1649183578288.png

 

2 REPLIES 2
Tanai_Goncalves
8 - Asteroid

Hello,

 

You have a complex pivot table. Not sure if you can got this on Alteryx, but i think the best way would be using cross tab and table tool.

 

Tanai_Goncalves_0-1649184305311.png

 

I'd prefer to just update the "Data" tab with Alteryx, and keep using the pivot table of excel, which is more dynamic. 

 

Ore use another visualization tool, like Tableau, Power BI.

 

Hope this helps,

 

Tanai.

 

jordanmount6
8 - Asteroid
Labels