Hi,
I have a sample data that looks like this:
Life | Paul | John | Betty | Method |
3 | 100 | 500 | 1000 | Method 1 |
5 | 200 | 600 | 2000 | Method 1 |
7 | 1000 | 700 | 3000 | Method 1 |
15 | 150 | 800 | 4000 | Method 1 |
39 | 40000 | 900 | 5000 | Method 1 |
3 | 10 | 450 | 900 | Method 2 |
5 | 30 | 550 | 800 | Method 2 |
7 | 500 | 650 | 700 | Method 2 |
15 | 200 | 750 | 600 | Method 2 |
39 | 30000 | 950 | 500 | Method 2 |
And I would like to use the Report Tool to make the end result look like this:
In essence, I need two header rows one for the person's name and then underneath that person's name method 1 amounts and method 2 amounts. I have attached the sample data and desired output.
Any help would be much appreciated!
Solved! Go to Solution.
Hi @ajapczynski ,
There is no native way of doing that, but here is a great example from @JohnJPS .
https://community.alteryx.com/t5/Alteryx-Designer/Multo-row-header/td-p/29185
Best,
Fernando Vizcaino
Thanks that worked!