+ Reply to Thread
Results 1 to 7 of 7

Pivot Chart - unusual average conumdrum

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    161

    Re: Pivot Chart - unusual average conumdrum

    You've done exactly what I did MarvinP - I have built a Pivot like that, with a manual formula
    Sorry for not attaching a sheet.
    The problems are:
    1 - I need to display all the columns in my Pivot, and the traditional way of displaying stats within the sport, is exactly in the order as shown, so that the riders average is shown after Points and Bonus Points.
    2 - Each time I add a year/rider, the manual formula will continually need to be added, and takes out the automated nature of the pivot, where I only need to change the data source traditionally.
    3 - I need to sort the pivot by highest to lowest average.

    ---------- Post added at 05:00 PM ---------- Previous post was at 04:08 PM ----------

    I solved it MarvinP

    I have added a Calculated Field with this formula:
    = (Points+Bonus)/Rides*4
    I can then put that in the Pivot anywhere I need it.
    *EDIT*
    In fact, I altered this to account for zero's thus:
    =IF(R =0,0, (Points+Bonus)/Rides*4)
    Last edited by neil40; 07-25-2012 at 12:16 PM.

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

    Re: Pivot Chart - unusual average conumdrum

    Hey Neil40,

    Could you attach your pivot table so we could all see how you did a Calculated Field. I'd like to check the calculated field answer agains the one I gave.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

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