Visualizing Cumulative Sum with Year-Month Filters - Qlik Sense

[DavideProtasi]

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!