Hello dear Alteryx Community, i need your help
I have a table with qualitative and quantitative columns. (see image)
The idea is to transpose the January and February columns and keep the qualitative columns (ID, CODE) and the SALES column as they are.
to do so i, i selected the ID, CODE, January, and February columns. Then I transposed February and January
in the result i have this :
The problem is that the sum of the output sales is not correct.
I've tried grouping the Sales column by ID and code, but neither the sum nor the average gives me the right amount at the end. Could you tell me what is the right method to do in this case please?
thank you in advance for your help
