Pivot Table is missing the last row

Occasional Visitor

Hey guys

I want to build a pivot table, I have 8 columns and they have different numbers of rows. I selected all the fields I needed to create the Pivot table but it never counts the value of the las row in every of the columns. Even if I choose only one column to make a pivot table it wouldn't count the value in the last row. I already refreshed the data and selected the data again but it doesn't help. You have any ideas what the problem could be?

1 Reply


Perhaps you may share sample file?

In general PivotTable is built on 2D range or structured table, columns in them can't have different number of rows. That is n rows x m columns area. Check PivotTable source if the row in question is included.