Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I'm struggling trying to visualize warehouse stock levels with Year-Month filters.
The one below is the data table of the stock in/out movements for two items (assuming no stock in the warehouse before 17/11/2022)
ITEM | Date | Stock In/Out |
1 | 17/11/2022 | 2 |
1 | 28/11/2022 | 1 |
2 | 14/11/2022 | 7 |
1 | 16/12/2022 | -1 |
2 | 14/12/2022 | -1 |
1 | 03/01/2023 | 2 |
1 | 15/01/2023 | 3 |
2 | 27/01/2023 | -2 |
1 | 15/02/2023 | 9 |
2 | 17/02/2023 | -2 |
No problems visualizing stock levels in a bar chart with
RangeSum(Above(Sum(Stock In/Out), 0,RowNo()))
Year-Month | Stock In/Out No Filters | Stock Level No Filters |
2022-nov | 10 | 10 |
2022-dic | -2 | 8 |
2023-gen | 3 | 11 |
2023-feb | 7 | 18 |
but only if I don't apply filters on the bars dimension (year-month)
How can I visualize stock levels of just some months without losing the information about stock movements of the other months?
I'd like to filter, for example, from dec 2022 to feb 2023, and obtain stock levels for item 1 (data below)
Year-Month | Stock In/Out Item 1 Dic2022-Feb2023 | Stock Level Item 1 Dic2022-Feb2023 |
2022-dic | -1 | 2 |
2023-gen | 5 | 7 |
2023-feb | 9 | 16 |
Right now this is what I get (november's data not used in the cumulative sum)
Year-Month | Stock In/Out Item 1 Dic2022-Feb2023 | Stock Level Item 1 Dic2022-Feb2023 |
2022-dic | -1 | -1 |
2023-gen | 5 | 4 |
2023-feb | 9 | 13 |
Let me know if you need any additional information about and thank you for your help!