qlik straight table

[cedfoning]

Hello, can you help please  ?

i have a straight table below :

I want to do the following:
1 ) when I filter, I want the values that are all at zero (like framing in black in the picture) to always remain. No matter what filter I do.

Here is the data model

2) Also, I want to have the subtotals by number (the second column). i.e. :
for the numbers starting with 1, we have a subtotal
for the numbers starting with 2, we have a subtotal
etc

thanks

[Or]

You can't have subtotals in a straight table. You'll have to use a pivot table if you want subtotals (unless you want to inject subtotal rows into your actual data as a workaround, which you probably don't).

Values of 0 will remain in your table as long as you don't filter out their matching dimensions, providing you're showing zero values in your table to begin with (should be under Data Handling, I think).