Results 1 to 8 of 8

How to calculate percentage in a pivot table (from a tally)?

Threaded View

  1. #1
    Registered User
    Join Date
    07-21-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    12

    How to calculate percentage in a pivot table (from a tally)?

    Hi,

    I have created the following pivot table. (Please see the excel file attached here).

    I have used the pivot table to display Total Wins and Losses.
    However, it seems I am unable to calculate "Win %" in the pivot table. I want to ONLY show the percentage of Wins (vs losses).

    My original data is included in the attached file. It uses a 'tally' to record Wins and Losses.
    Simply: If there is a '1' in the Win Column, that means a win. If there is a '0' it means a Loss.

    Could someone kindly help me do this?

    My EXCEL file: cumul raw separates.xlsx

    Illustration of my data: http://imgur.com/mzHMGdz

    To be clear, the pivot table shows "Character" and "Opponent".
    So here it shows that "Fox vs 'Opponent:' C.Falcon" is 2 wins, and 0 losses. Instead of showing this, it should show his % win. So it should say 100%. Because Fox beat C.Falcon 2-0.

    Ideally, I would like to add this function in the pivot table (if possible).

    Hope you can understand!
    Last edited by o0o0OoO0o0O0oo00o0O0; 07-22-2013 at 11:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to calculate percentage change between values in a pivot table
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-03-2013, 01:48 PM
  2. Replies: 1
    Last Post: 01-22-2012, 01:06 AM
  3. Replies: 2
    Last Post: 05-18-2009, 09:14 AM
  4. Replies: 1
    Last Post: 03-23-2009, 03:47 AM
  5. Insert rows alternatively in Pivot Table to calculate percentage of fixed ranges
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2008, 12:19 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