Values in Pivot are Averages, want total/subtotal to be sum of the averages

**PC41** · 05-12-2014, 03:52 PM

Hello all and thank you for your help in advance. I was wondering if there is a way in a pivot table to have your values average, but have your totals or subtotals be the sum of the averages in that row/column as opposed to them being averages still? Assume the below is a pivot table and my vales are set to average, when I leave the grand total option on for columns it shows the average of 50 (150/3) but I would like for it to show 150 the total of the 3 averages.

Assembly Avg 50
Diaasassembly Avg 50
Paint Avg 50

Grand Total 50 (shows in pivot)
Grand total 150 (want it show the some of the 3 averages)

**oeldere** · 05-12-2014, 03:56 PM

Your looking for a running average ?

If so, yes that is possible.

**cbatrody** · 05-13-2014, 01:04 AM

Hi,

Can you please post a sample template of your workbook here?

**PC41** · 05-13-2014, 08:37 AM

Here is a basic example of what I am trying to achieve. When I have my values in the pivot set to show averages with the grand total option on it calculates in the avgerages format as well, I was wondering if you could have that show the sum of the averages in the table. Thank you for helping.

**oeldere** · 05-13-2014, 11:36 AM

Running total (like this)?

See the attached file.

**PC41** · 05-13-2014, 12:05 PM

Originally Posted by oeldere

Running total (like this)?

See the attached file.

Sorry the previous attached file was not refreshed. I just want the sum of the averages to be shown in the grand total, not the average of everything. I want what is highlighted (175) in this attachment to equal what is in the grand total column (sum of the value averages), not the 91.67 (the average of all values). So I guess is there a way to have the grand total reflect sum of the value field while your values are averages?

**oeldere** · 05-13-2014, 12:49 PM

with an helpcolumn.

See the attached file.

**PC41** · 05-14-2014, 12:11 PM

Originally Posted by oeldere

with an helpcolumn.

See the attached file.

Thank you that works, I guess I can just hide the extra un-needed columns?

**oeldere** · 05-14-2014, 12:26 PM

Glad I could help.

Of course you can hide un-needed columns, but why would you do that.

What is the use for that?

**PC41** · 05-15-2014, 01:57 PM

Originally Posted by oeldere

Glad I could help.

Of course you can hide un-needed columns, but why would you do that.

What is the use for that?

The other sum columns in the body of the table are not needed, just want to see the avgs in the body of the table and the sum of avgs in the grand total column.

Thanks again!

Values in Pivot are Averages, want total/subtotal to be sum of the averages

LinkBack

Thread Tools

Rate This Thread

Display

Values in Pivot are Averages, want total/subtotal to be sum of the averages

Re: Values in Pivot are Averages, want total/subtotal to be sum of the averages

Re: Values in Pivot are Averages, want total/subtotal to be sum of the averages

Re: Values in Pivot are Averages, want total/subtotal to be sum of the averages

Re: Values in Pivot are Averages, want total/subtotal to be sum of the averages

Re: Values in Pivot are Averages, want total/subtotal to be sum of the averages

Re: Values in Pivot are Averages, want total/subtotal to be sum of the averages

Re: Values in Pivot are Averages, want total/subtotal to be sum of the averages

Re: Values in Pivot are Averages, want total/subtotal to be sum of the averages

Re: Values in Pivot are Averages, want total/subtotal to be sum of the averages

Thread Information

Users Browsing this Thread

Similar Threads

Pivot Table - Multiple totals with averages and rank / Total to average with criteria

Filtering averages on averages generated by the filtering - circular reference prob

Excel 2007 : Pivot Table Averages based on Unique Values

Formula, Averages by name, and differences of averages

Cal averages in columns to exclude blank fields:calculate averages

Bookmarks

Bookmarks

Posting Permissions