Good Morning Alteryx Community,
I have a very easy problem today but I just seem to not be able to wrap my head around it to get my solution. I have the following data following my calculations.
| Group | Total | Total count age group | Total count per group | % in group | % in Total |
| 8+_IN | 100 | 57 | 45 | 78.95% | 45% |
| 8+_OUT | 100 | 57 | 12 | 21.05% | 12% |
| 8-_IN | 100 | 43 | 41 | 95.35% | 41% |
| 8-_OUT | 100 | 43 | 2 | 4.65% | 2% |
I am looking to take the total number IN (45 & 41) out of the total (100) and then the total number OUT (12 & 2) out of the total.
So basically, I am looking to create 2 new cells that use the formulas/cells above to show me the total percentage in and the total percentage out. If you could include a workspace, I would greatly appreciate it.
I am sure that this is a simple fix but I for some reason cant figure it out and would greatly appreciate a workspace to show me where my error lies.
Thank you so much in advance,
Nick
