Forum Discussion
Solved
Stock quantity counting help
Hi, I have the following problem. My matrix countains products, currentstock at time, and current price at the time. As you can see, this product started with 40 stock, and gets low...
Hi, i found the solotion. In the item table for each row i created a new cumulative sum column. After that, i created a measure that gets me the max ID for each date. After that i know the row with the quantity i am looking for.
sorry, looks like the entire row for item 61 is needed in the header table. or can it be dropped from the details table?
Hi, i found the solotion. In the item table for each row i created a new cumulative sum column. After that, i created a measure that gets me the max ID for each date. After that i know the row with the quantity i am looking for.