SOLVED
Hello All - I have been troubleshooting an issue for a couple of days and figured I'd give the community a shout out.
My objective is to replace the Expected Category Item Values with the Observed Category Volume Value for each corresponding month. Below is a before and after example of how the output would look. Does anyone have a suggestion on how this can be done within the Alteryx environment!? Thanks.
Solved! Go to Solution.
I suggest the following.
Use a filter to get the observed volume values
Then join this back to the original set
To ensure no loss of records use a union to merge Left and Join output
Finally, a formula to correct value
Quick sample attached
