How to calculate the material on stock sum for each material.

[Yashh]

Hello all,

I want to calculate the material on stock for each material. How can I do it?

[Arul]

@Yashh ,

Just drag and drop the Material and material stock column to your visual it will provide the summarized result. I believe your material stock column is whole number datatype and it's summarization type was set as sum.

Thanks,

Arul

[Yashh]

hello @Arul, 

 I dont want the sum of material on stock I want to have the available quantity as zou can see it is decreasing 

I want to have the data as for material 128  material on stock is 1900.