I have created 2 calculated item in my pivot table excel (total créance and total retard ). However, empty rows are still displayed. If I delete the calculated item, the rows disappear.
I have tried hiding empty items in the field settings and applying filters with different values, but without success.
How to display a calculated item in an Excel pivot table while excluding empty rows or cells?