Accumulative sum against stock qty

[JuanVR10]

Hi friends!

I have 2 tables, one is MB58, which shows by Cliente and Material the available stock. And another table SEGUIMIENTO PEDIDOS, which details the units consumed by Cliente, material and dispatch date.

What I have to do is: in a PBI table visualization shows only the records of the SEGUIMIENTO PEDIDOS table that for the Client/Material the number of dispatches that add up to the total MB58 for the same Client/Material, counting from the dispatch date most recent towards the oldest, that is, if for a material X, the stock says 30, only the records of the SEGUIMIENTO PEDIDOS table will be shown whose quantity adds up to 30 considering the most recent dispatch date.

I've tried several ways, but it still doesn't work for me.

Do you have any ideas? I hope you can help me.

Thanks!

[v-henryk-mstf]

Hi @JuanVR10 ,

Based on your description, it does not seem to match the data provided in the table. My confusion is: is there a relationship established between the two tables (cliente field or something else?) ; additionally how can I count the quantities under the same inventory?

Can you check the relevant data model and explain it so that I can answer it for you as soon as possible? Looking forward to your reply.

Best Regards,
Henry