Can't hide zero value calculated items in a pivot table

[pdecrocq]

Hello,
I need help to find a way to hide zero value calculated items in a pivot table.
So far I have tried a number of tricks at no result.
I have a database for CO2 tons emissions for 2021 for a number of scopes and subcategories for some countries and locations.
I need to compute 2025 estimations by applying a coefficient to some 2021 values.
I have a done a pivot per rows = Category / subcategory. Columns = Years, E values = Sum of tCO2eq.
I'm adding two calculated items to the Years field.
The first is "Coeff" and its formula is "= 1"
The second is "2025" and its formula is "= '2021' * Coeff".

As soon as I enter the Coeff calculated item a number of additional rows appear for all categories with "0" values, whereas before only the rows with values would appear.
I can't find a way to hide the zero values lines.

Can someone help me ?

Thanks,
-Pierre

 

[pdecrocq]

Note: this same question has been raised on Excelforum too (with a sample attachment).
Link Can't hide zero value calculated items in a pivot table
Note 2 : I'm unable to find how to attach the same sample here, so I left the question without the sample XL file.