Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Transpose and aggregate data

Alt_dp
7 - Meteor

Team, 

 

I'm trying to aggregate data that is stored diagonally but having hard time to get it done.  As an example, in the attached file, all the cells that are blue in color should be aggregated and return the value in cell B13. Similar for all the other colors. 

 

Appreciate your help. Thank you!!!

 

3 REPLIES 3
Alt_dp
7 - Meteor

Ideally if i can move the data as shown in the excel, that would work too

Thableaus
17 - Castor
17 - Castor

Hi @Alt_dp 

 

I was able to reach your layout. I leave up to you how you do the aggregations.

 

Solution121232.PNG

 

Workflow attached on version 2018.4

 

Cheers,

Alt_dp
7 - Meteor

Thank You Thableaus!!!

Labels