Results 1 to 7 of 7

Pivot Chart - unusual average conumdrum

Threaded View

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

    Pivot Chart - unusual average conumdrum

    Hi

    I have a series of Spreadsheets for Speedway results. (Motor bikes)

    On any particular sheet, a riders average is calculated as ((Points+Bonus)/Rides)X4 - this gives a consistent average for all team members based on a usual set of 4 rides per meeting.

    The Chart to show this would have columns
    Name/Rides/Points/Bonus/Average/wins/seconds/thirds/fourths/Exclusions

    However, when I create a further spreadsheet, to collate multi seasons with a pivot chart, the column for Average doesn't work, as it doesn't fit the 'Summarize field by' criteria, IE it isn't a Sum of averages, or a count of averages, as it will always be as per the calculation above.
    I would prefer to have the Average column in the same place, and the only way I have thought to do this is a regular formula outside the Pivot.
    This produces several 'problems'
    a) It isn't in the place I want it
    b) I want to sort the table by Highest to Lowest on these averages, which obviously works automatically on the Pivot data if I tell it which to sort.
    c) As seasons progress, and riders are added, I have several changes to make, not only in Source data, but then also adding the extra manual formulas.

    I hope all this makes sense, and wondered if anyone can think of another way around this?

    Cheers
    Neil
    Last edited by neil40; 07-25-2012 at 12:02 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