Results 1 to 3 of 3

Weighted Average in Pivot Table

Threaded View

sinspawn56 Weighted Average in Pivot... 03-23-2012, 11:25 AM
mahju Re: Weighted Average in Pivot... 03-24-2012, 02:25 PM
sinspawn56 Re: Weighted Average in Pivot... 04-05-2012, 05:26 PM
  1. #1
    Forum Contributor
    Join Date
    02-13-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2015
    Posts
    183

    Weighted Average in Pivot Table

    I am trying to make a pivot tabs that shows me a weighted average in a calculated field but I cannot seem to get the formula right. I look at a few thread that attempted to do the same thing, but they are not working.

    I calculate weighted averages using the following formula:
    =SUMPRODUCT("dataarray1","dataarray2")/SUM("dataarray1")
    But I cannot figure out how to do that in a calculated field.
    Attached Files Attached Files
    Last edited by sinspawn56; 04-05-2012 at 05:26 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1