- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Accumulative sum against stock qty
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-11-2024 06:48 AM | |||
11-18-2024 06:18 PM | |||
04-04-2024 11:58 AM | |||
09-22-2024 12:02 AM | |||
09-04-2024 12:50 PM |
User | Count |
---|---|
137 | |
107 | |
84 | |
59 | |
46 |