transform tool help

[Kiara16]

i am very new to alteryx, i have two sheet as attached order sheet has all the info i just want to have the data in order % sheet format. i am unable to get this and also how to fetch month in order sheet by number ? can somebody help me to walkthrough this!!

[aatalai]

@Kiara16 does this help? not sure how you calcuted period

[Kiara16]

No, actually i want to consider order sheet as an input and output sheet should be in the format of order % sheet

month is nothing but denoted by number

1 as in jan

2 as in feb

3 as in march

[aatalai]

ok what does period mean?

But does this help (directionally)?