New Alteryx user here---Reorganize my rows and columns? Then calculate percent

[irmb]

Hello everyone , I am completely new to Alteryx and need help. I one record with three columns that is  the result of a summarize. The 3 columns are these:

Sum_total number of people 2010

Sum_total number of people 2011

Sum_total number of people 2012

then I appended to another table that also has 1 record with three columns. These are the 3 columns that were appended to the previous ones:

Sum_total people with pets 2010

Sum_total people with pets 2011

Sum_total people with pets 2012

I need to figure out the percent of people with pets for each year. In order to do that, I would think I need to reorganize my table into several rows and columns, then perform the percent calculation. Is that so?  Also, how do I do the percent calculation in Alteryx? Any idea of how I do that?

[yalmar_m · Accepted solution]

Hi @irmb,

Is this solution suitable for you?

- Transpose the columns to rows

- Determine the year

- Join on year

- Calculate the percentage

Please find the solution attached.

Best,
Yalmar

[irmb]

Thanks @Yalmar

Yes, this is the logic and I was thinking about. I tried to upload the workflow to my version of Alteryx designer and it says that I don't have the latest version and I don't have access through the new version through my company. Can you share a file that I can upload?

[irmb]

Thanks, I was able to open it. It works now.