+ Reply to Thread
Results 1 to 3 of 3

Calculating the average score from three diffrent tables within Power Pivot

  1. #1
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    385

    Calculating the average score from three diffrent tables within Power Pivot

    Hi All

    I was wondering whether there is an easy way to do the following:

    I have a Pivot Report created from Power Pivot. This report extracts the data from 3 diffrent tables which all have a realtionship built up together. The colunns in the final Pivot are % Sales, % Perfromance and % Refunds.

    What I need to do is tho claculate the average of the three columns. I cant create a measure, I was wondering whether there is a formula like GetPivot or anither way from insode the pivot table (creating a field) that I can claculate the average of three scores and then rank them.

    Hope this makes sense

    Thanks in advance

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,345

    Re: Calculating the average score from three diffrent tables within Power Pivot

    Hi rv02,

    I used to teach math and have a problem with "averaging percentages". Sure you can add the numbers and divide by how many there are but your answer may not be what you want. Read:
    http://mathhelpforum.com/algebra/353...nts-print.html
    to see if you really want this calculation from your numbers.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    385

    Re: Calculating the average score from three diffrent tables within Power Pivot

    I have explained this wrong, what I have done is raked the percentages and then averaged them out but each component will have a different weight as Sales will have 50% and other components will have 25% each. I hope tbis is correct way of doing this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Question on Updating my Pivot Tables and Power Pivot in my workbook
    By rv02 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-29-2015, 06:08 PM
  2. [SOLVED] Power Pivot join tables question
    By ericedholm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2013, 10:53 AM
  3. Date formats in pivot tables using power pivot in Excel 2010.
    By myobreportguru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-25-2013, 10:21 PM
  4. Replies: 2
    Last Post: 03-06-2013, 06:43 AM
  5. Replies: 2
    Last Post: 03-05-2012, 03:56 PM

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