I have been asked to build a table by month and year that shows the number of open items in a storage.
I want to build a table that would not be affected by the user's selections, the table will display by month and year the amount of items in the storage , for example in February , the relevant data will be all the items that the enter date is less than 28.02.2020, i.e., all the items that enter in January and February 2020.
a table with a dummy data:
*I also attached the excel file*
Item that has entered on 15.1.2020 and was out on 21.02.2020, In the "Final column" I need to count this item only one time in the January month row ,this item will not be calculate on February because the date out is less the 28.2.2020 .
How can I Build the expression in the "Final column"?