Start Free Trial

Alteryx Designer Desktop Discussions

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

Formulas

bsolove
8 - Asteroid

I have data that looks like the attachment below.  I want to sum the categories by state if there is an X in the category over to the right.  I am not sure how to do this.

1 REPLY 1
jasperlch
12 - Quasar

Hi @bsolove

 

This could be achieved by first Transposing the table and then split the table to 2 and join them back together:

 

Capture1.PNG

Labels
Top Solution Authors