Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables in excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pivot tables in excel
Resolved · Medium Priority · Version 2010
Reply Fri 3 Jun 2011, 15:03Delegate Nick said...
Nick has attended:
Excel Advanced course
Pivot tables in excel
if i set my field setting to show averages, can i somehow get a sumtotal of those values which then updates even if new values are added to the field when the data is refreshed?
For upcoming training course dates see: Pricing & availability
RE: pivot tables in excel
Hello Nick,
Hope you enjoyed your Microsoft Excel Advanced course with Best STL.
Thank you for your question regarding field settings in your PivotTable.
The field that you added to the value section which you have formatted as an average can be added again to the values section, this time as Sum of [field name]. This of course makes the PivotTable bigger, but it works and also updates when refreshed.
If you only want a sum total of the average figures, then all you do is create a sum formula below the PivotTable which sums all average figures above. This will also update when the PivotTable is refreshed.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Mon 13 Jun 2011: Automatically marked as resolved.
|