Why Is There No Data in My PivotTable?

Author: Joyce Zhou

Symptom

You can connect to Kepion cubes using Excel and perform data analysis through Excel PivotTables. To learn how to build Excel PivotTables, please refer to this article.

Sometimes you may reach an empty table even if you set the axis correctly. See the example below.

Resolution

The reason for this can be one of the following:

1. The highest level of table headers (in this case, Account dimension) doesn’t contain any data.
2. By default, PivotTables only display table headers in collapsed view (i.e., show the highest level nodes only).
3. By default, PivotTables don’t display empty rows and columns.

To display data in the table, we should follow these steps:

Step 1. Right click on the PivotTable and select PivotTable Options…

Step 2. Check the box before Show items with no data on rows and Show items with no data on columns. Click OK.

Now you should be able to see the table with full axis information according to your PivotTable selections.