Closed Thread
Results 1 to 2 of 2

[Urgent]Calculating percentage in pivot table

  1. #1
    Registered User
    Join Date
    06-08-2015
    Location
    HK
    MS-Off Ver
    365
    Posts
    4

    [Urgent]Calculating percentage in pivot table

    Hi all,

    I am new to excel pivot table and I would like to ask one question about pivot table:

    I have maded a pivot table which the rows show month (e.g. 1,2... 12), the columns show name of staff( e.g. Peter, Marco etc), a logic indicator (either 1 or -1), the filter is year (different years like 2012,2013,2014), the values is using count numbers where it counts the number of data that belongs to 1 and -1 respectively.

    Now I want to create a column in pivot table which calculates the following:

    (Total number of data that belongs to 1)/( (Total number of data that belongs to -1) + (Total number of data that belongs to 1))*100

    How I can deal with it?

    Thank you so much!

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: [Urgent]Calculating percentage in pivot table

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pivot table Help with calculating a pass fail percentage
    By NoobSupreme in forum Excel General
    Replies: 2
    Last Post: 08-04-2014, 05:04 AM
  2. Pivot table - calculating percentage on grand total
    By sri023 in forum Excel General
    Replies: 3
    Last Post: 07-13-2012, 02:42 PM
  3. Replies: 5
    Last Post: 06-08-2012, 03:24 PM
  4. Calculating a percentage from a table that will grow
    By Mawhood in forum Excel General
    Replies: 1
    Last Post: 01-28-2010, 02:23 PM
  5. pivot table error.Please help! very urgent
    By anu_manu in forum Excel General
    Replies: 0
    Last Post: 02-13-2006, 04:34 PM

Tags for this Thread

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