This can be done in a few minutes by dragging fields with the mouse. They automatically summarize and group data without formulas.

The key skill is configuring the "Values" area, where you can change the operation from sum to average. But it's important that the source table has no empty rows.

Often the problem is that the report does not update when data changes. This usually happens due to four typical mistakes. We analyze the reasons why a pivot table does not update and how to fix it.

🔗 Source: excel.rf