Introduced to Excel 20 as an add-on, but now native to the application, Power Pivot is part of Microsoft's business intelligence stack capable of (but not limited to) big data analytics work without specialty infrastructure or software.

To force the Pivot Table to display zero when items have no data, enter a zero under the Layout & Format tab of PivotTable Options. On the Analyze (or Options) tab, in the Active Field group, click Active Field.ĥ. Select a field in the Values area for which you want to change the summary function of the PivotTable report.Ĥ. If your PivotTable is not connected to Kepion, you must complete a few more steps to display see the table with full axis information.ģ. If you are connected to Kepion, you should see the table with full axis information according to your PivotTable selections.

Check Show items with no data on rows and Show items with no data on columns. Right-click the PivotTable and select PivotTable Options…Ģ. Tip: If you would like to learn how to build Excel PivotTables, please refer to this article.ġ. In this article, we will show you steps on how to display fields without any available data. By default, PivotTables don’t display empty rows or columns.By default, PivotTables only display table headers in collapsed view (i.e., show the highest level of a hierarchy if connected to Kepion).The highest level of table headers (in this case, the Account Dimension) doesn’t contain any data (if connected to Kepion).

The primary reason for this is that PivotTables, by default, only display fields where data exists for the specified row, column, and Filter selections.

Pivot tables in excel values