Avg in a Pivot?

C

confused

Is there a way to calculate an average in a pivot

I am trying to calculate by qtr the avg # of products included in new sales

my data is by qtr, sale name, sales area and then products and is tagged if
its a new deal

So first I tried creating a pvt and filtering on new and then counting
product name but don't know how to create an extra column to to do an
average. Some sales could have 5 products, while others 20 or even 1. Any
ideas? Thank you!!!
 
T

Tammyp

This is very easy once it is explained. When you are inserting the pivot
table and you have the data inputed in your fields, under the values field
click on it and then click the value field settings. In that option you are
able to click average.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
average of sumed data in pivot tabel 3
Calculation of Gross Margin in a pivot table 1
calculating differences in a pivot table 3
Linking labels in a pivot table 1
Pivot Table 1
Calculate Average in pivot item 6
Calculating percentage growth rate from a cumulative figure 4

Top