+ Reply to Thread
Results 1 to 2 of 2

Pivot Table % calculation

  1. #1
    Forum Contributor
    Join Date
    09-15-2005
    Location
    Florida
    MS-Off Ver
    Excel Professional Plus 2016
    Posts
    142

    Pivot Table % calculation

    With out using formulas, can pivot table calculate % of the following example attached?

    Count of implemented by and count of Month live on EPCS

    I tried all options in the show value as.

    Ideally, I would like another column (not using formula instead within the pivot table):

    Flor Garcia 45 32 71% as an example.

    Thank you in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,913

    Re: Pivot Table % calculation

    Since you have 2016 Pro Plus. You can add DAX measure to do this.

    1. Add the table to data model.

    2. Add following DAX measure (right click on the table in Pivot Table Fields pane).
    =DIVIDE([Count of Month Live on EPCS],[Count of Implemented By],0)
    0.JPG

    3. Add the measure to values field.

    See attached sample.

    NOTE: This sort of calculation is impossible in traditional pivot table (without adding helper column(s) to source table).
    Attached Files Attached Files
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. Calculation in Pivot table
    By haitham.shop in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-23-2017, 03:49 AM
  2. Calculated pivot table field using pivot table data in calculation
    By BrittleStar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-10-2012, 05:35 PM
  3. Pivot table & calculation help
    By go4cdt in forum Excel General
    Replies: 0
    Last Post: 08-03-2011, 01:03 PM
  4. Pivot Table Calculation
    By briandrago in forum Excel General
    Replies: 2
    Last Post: 01-29-2009, 05:27 PM
  5. Doing a calculation in a pivot table
    By Gazzr in forum Excel General
    Replies: 1
    Last Post: 01-07-2009, 03:45 AM
  6. Need Help on Pivot Table Calculation
    By charlesoutcalt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2007, 04:08 PM
  7. [SOLVED] Pivot Table % calculation
    By jerry in forum Excel General
    Replies: 2
    Last Post: 10-07-2005, 02:05 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