+ Reply to Thread
Results 1 to 2 of 2

pivot table embedded formula

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Panama
    MS-Off Ver
    Excel 2007
    Posts
    90

    pivot table embedded formula

    Good day,

    I want to add an embedded formula to a pivot table,

    for the below example I want the field "Score" with value 4 + field "Score" value 5 / total Score

    (Score[4] + score[5]) / Score

    ActiveSheet.PivotTables("PivotTable1").PivotFields("Overall Satisfaction").PivotItems("4")
    +
    ActiveSheet.PivotTables("PivotTable1").PivotFields("Overall Satisfaction").PivotItems("5")
    /
    ActiveSheet.PivotTables("PivotTable1").PivotFields("Overall Satisfaction")


    int he example below ...

    Agent X% = 40 + 70 / 172 = 64%

    Score
    Agent 1 2 3 4 5
    X 36 11 15 40 70
    Y 10 9 10 12 69
    Z 58 10 9 19 44

    I can use the field =GETPIVOTDATA("Score",$B$4,"Agent","X","Month",1,"Week num",1,"Score",4)

    or simply just use (F8+G8)/H8, however wanted to see if this could be done with an embedded formula,

    thanks for your time,

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: pivot table embedded formula

    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.

    http://www.excelforum.com/excel-char...ic-fields.html

+ 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. Pivot table embedded function with specific fields
    By Zealotwraith in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-30-2013, 03:52 PM
  2. Adding formula to active table and for pivot table in macro
    By Jerseynjphillypa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2012, 08:12 AM
  3. Excel 2007 : Embedded Offset formula within a Table
    By Ra21V12eN in forum Excel General
    Replies: 2
    Last Post: 07-29-2009, 07:50 PM
  4. Excel Pivot Table embedded in Form
    By maggl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2009, 01:27 PM
  5. Embedded IF in pivot table
    By Crey23 in forum Excel General
    Replies: 0
    Last Post: 03-09-2005, 12:42 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