PivotTable

Recently when I add a calculated field in an excel PivotTable, I encounter the error An item name cannot be found, check that you’ve typed the name correctly and the item is present in the PivotTable report. In this article, I will tell you how to fix this error.

In this article, I will tell you how to use excel formulas in a PivotTable to perform calculations and add custom fields to the PivotTable. This is very useful in some use cases.