Natalie has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
Pivot Tables
How do you calculate the
average figure from existing data.
RE: Pivot Tables
select the field settings option and select average.
RE: Pivot Tables
This does not answer my question, i want to calculate the average based on the figures in the pivot table. Example. i have so many number orders for 5 months of the year. i need to have within the pivot table result the average no of orders over the five 5 month. Natalie
RE: Pivot Tables
Can you send me a spreadsheet through so I can have a look at it?
paul@stl-training.co.uk
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
