After using crosstab my data is flowing in different columns, Ex: if there is item Car allowance and it has amounts in all 12 month it is flowing in separate row for each month where i need all month value in single row
As shown in picture i want data to be aligned as per blue line
Solved! Go to Solution.
You have something not in the pictured clicked as a key field. Without seeing the rest of your data I can't diagnose exactly what it is - but go back to your crosstab tool and see what columns you have clicked as key fields.
@apathetichell i have selected "Sum"
Hey @Sanjana_HS,
What are the key fields you have selected? Could you give a small example dataset? The cross tab tool can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done
@Sanjana_HS Can you provide some sample input data and expected output result?