the following represents my table:
The table displays all items with ship date and qty.
We would like to know how much qty per each stock code we will need to fulfill in the near future. For this I have the ageing buckets.
Current is not to two weeks period , more than 2 weeks, over 4 weeks, and everything over 6 weeks.
In order to achieve that i would need to convert data to the following format:
Can I have some help in creating a view to display the above? thanks