oswt hasI'm hoping someone has the solution to my problem, I'm thinking that I'm just doing this the wrong way...
The data is based on a table called Item_Entries.
The table consists of rows, these have data with Amount, Amount Sold, Remaining Amount, Salesprice, Costprice.
What I need is to be able to select a date period, could be 01/01/20 to 30/06/20.
The "Total sales in period" column works fine, since it looks at the entries in the filtered period, and looks at total sale amount (salesprice * total Amount Sold).
My issue is with the first column, "Inventory Amount".
This column needs to use the "Remaining amount" data on the Item Entries. The problem here is that i need this measure/column to look at ALL data, from the very beginning, to the last date specified in my filter. So this measure actually needs to look at data from company start date, to the last date of my filter. That would be 01/01/18 to 30/06/20.
How do I handle this? I'm assuming I need to remove the filter on the "Inventory Amount" measure, and then apply something that always picks filter from start, to the last specified dato. I just cannot figure how to do this, and maybe I'm just going at this all wrong.
I'm hoping someone will be able to figure out what I'm trying to do.
Thanks in advance.
| Item No. | Inventory amount | Inventory value (cost) | Inventory value (salesprice) | Total sales in period | Inventory days by months |
| 1 | 140,746 | 281,492 | 562,984 | 140,000 | x |
| 2 | 100,414 | 150,621 | 301,242 | | x |
| 3 | | | | | |
