This can be a problem when it comes to formulas that rely on numeric values because Excel will convert text to 0 if it has no other way of evaluating your formula. The simplest way to deal with this ...

In this situation, you might consider converting your PivotTable to a formula-based report using Excel 2016’s new Cube-based functions and conversion tools. Once converted to formulas, your report is ...