I have a data with [Material], [Batch],[Movement Type], [Document Date] and [Time of Entry]. I want to create a column that would show the pattern of movement type according to date.
For example, Material / Batch – > 9121313 / 00471124 has movement pattern of 101 - 601. The pattern should follow the document date and time stamp. If the earliest transaction is 101, followed by 102 then finally 601, the pattern should be 101 - 102 - 601.
So I want to create a table like this:
How can I do this? This will help me explore the data regarding unusual patterns.