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

Top