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?
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
