Hi
The image below shows how the union is done- the final result is creating 2 rows for that specific order I am filtering on my reports and I need the order channel to be on the same row as the rest- I tried creating additional column by adding result column and use the MAX(saw_2 by saw_y) etc but did not work- any idea what I am doing wrong?
Thnks
Joe
