Скачать или смотреть Excel Pivot Table: How to Show Average instead of Grand Total

To display the average instead of the grand total in an Excel Pivot Table, follow these steps:

1. Click the Grand Total cell you want to change.
2. Right-click and select "Value Field Settings."
3. In the window that appears, choose "Average" from the list of summary functions (which by default is set to "Sum").

This will adjust the Pivot Table to show averages rather than the grand total.

Check the result: The Pivot Table should now display averages instead of sums, and you will no longer see a grand total (unless you choose to leave it).

Don't forget to 👍 like and 🔔 subscribe for more Excel and Pivot Table tips to simplify your workflow! 🚀

Timestamps:
⏰ 00:00 - Intro
📊 00:06 - Show Average
✅ 00:50 - Conclusion

#Excel #PivotTable #ShowAverage #GrandTotal

🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions:    • 💰 Compound interest calculator template in...  
🎥 Common errors:    • 🚨 How to solve the #DIV/0! error in Excel  
🎥 How to tutorials:    • How to use UPPER in Excel  
🎥 Regular functions explained:    • BASIC EXCEL FUNCTIONS