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?
