community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Transpose and aggregate data

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!!!

 

Meteor

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

Alteryx Certified Partner
Alteryx Certified Partner

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,

Meteor

Thank You Thableaus!!!

Labels