How to display all names from field even if the values are 0 for those?

Hi,

I have a table with the field store name and other field units shipped.

I would like to display all stores with the shipped qty until the selected month even if the shipping for the store was 0.

As example:

store1

store2

store3

store4

Then I filter all for January 2023 when all stores have shipped units, but store 3 has 0 units.

I would like to see it as below

Store January

store1 232

store2 444

store3 0

store4 5548

The issue I have is that whenever I put a filter and there is no shipping for the store it disappears.

I try to place formula:

{ FIXED [Store name]: SUM(IF [year] = [p_year_selecion] AND
[month] <= [p_month_selection] THEN [Shipped Units] ELSE 0 END) }

With this formula units shipped are correct if I do not place the filters - all fine,

but at the same time when I do not place filters for month, all months are displayed.

So instead of this:

Store January

store1 232

store2 444

store3 0

store4 5548

I have this:

Store January February March April ..... December

store1 232 232 232 232 .... 232

store2 444 444 444 444 ... 444

store3 0 0 0 0 ..... 0

store4 5548 5548 5548 5548 .. 5548

I also tried to have a separate table with store names and join it with the table with shipped units, but that also didn't work

Any solutions on that?