+ Reply to Thread
Results 1 to 2 of 2

Calculate % of custom value in pivot table

  1. #1
    Registered User
    Join Date
    09-17-2016
    Location
    Pennsylvania
    MS-Off Ver
    2013
    Posts
    13

    Calculate % of custom value in pivot table

    Hello all!

    I would greatly appreciate some input on the following:

    I have a pivot table that successfully organizes my data into one column with ID and one column that Counts the number of Sales made. It looks like:

    ID ........ Sales
    Susan.....3
    Bob........6
    Mark......7

    I would like to add a column next to sales that calculates the sales as a % of 25. In other words, 25 is my base value. So, it would look like:
    Susan .....3......12%

    I understand the idea of adding a Calculated Field; however, cannot seem to figure out how to base it off of 25, which is not represented in the dataset.

    Happy to clarify further if need be.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Calculate % of custom value in pivot table

    Hi,

    A calculated field will only sum and not count, so you will need to add a new column to your data that simply has 1 in each row- assuming each row is a sale.

    Then you can add a calculated field with this formula
    ='Field name'/25
    where Field Name is the name of the new counter column.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Custom Pivot table
    By jonespandrew in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-29-2016, 11:34 AM
  2. Calculate orders past agreed dates in pivot table and averages in pivot tables
    By applesandpears in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-18-2012, 05:26 PM
  3. custom pivot table calculations
    By rty1138 in forum Excel General
    Replies: 0
    Last Post: 07-22-2010, 06:10 PM
  4. Pivot Table: Using Custom calculation
    By alliseri in forum Excel General
    Replies: 2
    Last Post: 06-28-2009, 03:40 PM
  5. Pivot Table custom formula
    By pmguerra in forum Excel General
    Replies: 1
    Last Post: 03-10-2009, 10:15 AM
  6. custom pivot table value field
    By Bobboau in forum Excel General
    Replies: 1
    Last Post: 08-07-2008, 06:25 PM
  7. Custom Views in Pivot Table
    By Samad in forum Excel General
    Replies: 1
    Last Post: 01-12-2005, 10:06 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