Frequently asked questions during Excel PivotTable report use

frequently asked questions during Excel PivotTable report use

One, unable to create a PivotTable report

If there is a merged cell in the data source table that causes the title behavior to be empty, the field name is prompted to be invalid.

Second, the updated format is not

After the PivotTable report sets the column width or other formatting, the formatting that is set after the refresh is invalidated.

The trouble of counting items

Q: The finished PivotTable report shows the count, why not the sum?

A: The data source contains empty cells (including multiple-selection blank lines), you can select the first 2 rows to make a PivotTable report, and then modify the data source.

Four, date can not be grouped

Q: Why can't dates use the combination feature, by month group?

A: Date columns contain values that are not in date format, including text, numbers, or null values.

Five, "sum:" Cannot be deleted

If you want to delete the word "sum:" You will be prompted with an error. The workaround is to replace it with a space.