Demand Position for a Product across alllocations

Hi all,

I am working on a Report for "Demand Position for a Product across allocations".

Here i need to output values for various Location Categories (Plant, SMD, Buffer, JIT) like 'Opening Stock at JIT', 'Opening Stock at SMD' .... 'Closing Stock at JIT', 'Closing Stock at Buffer'..... If anyone have worked on this type of Report please send me the logic involved.

Thanks and Regards

Selva