Pivot table

Hi Maria,

Thank you for your question.

I will have a look at the problem after training today and email you any suggestions.

Regards

Simon

Hi Maria


Thank you for your question & apologies on the delay getting back to you.

To average a calculated field:
- right click one of the calculated field values
- From the menu select Field Settings
- From the list of available functions select Average.

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.


Regards,


Nafeesa

Microsoft Office Specialist Trainer