![]() To create a pivot table, you need a heading value for each column. The pivot table error, "field name is not valid", usually appears because one or more of the heading cells in the source data is blank. There is a pivot table field name at the top of each column. There are 7 columns of data, and no blank columns or rows in the list. ![]() If we check the source data for this pivot table, everything looks okay. If you are changing the name of a PivotTable field, you must type a new name for the field.” To create a PivotTable report, you must use data that is organized as a list with labeled columns.
0 Comments
Leave a Reply. |