Dec 18 2021 08:20 AM
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?
Dec 18 2021 09:47 AM
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.