+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Calculated Item Field Grand Total Not using Formula

  1. #1
    Registered User
    Join Date
    04-05-2007
    Location
    Lombard, Illinois
    Posts
    60

    Pivot Table Calculated Item Field Grand Total Not using Formula

    I have a pivot table which displays the number of transactions (Successful, Bad, Failed, #value) by day of the month. I've created a column with a calculated item field to get the percent of successful transactions each day. The calculated field adds success and bad transactions and divides the success transactions count by the success plus bad transactions count. The calculated item field is working good, except for the grand total. In the grand total row it is adding all the percents from each row and giving me a total percent. So, if I have 10 rows with a percent of 89%, the grand total is displaying 890%, which makes sense since it is the grand total row.

    How can I get the cell in the grand total row/calculated item column to use the same calculated item formula as the rest of the rows do and calculate the percent based on the other numbers on the grand total row?

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: Pivot Table Calculated Item Field Grand Total Not using Formula

    Hi,

    Please post a sample template of your workbook using "Go Advanced" option below.

  3. #3
    Registered User
    Join Date
    04-05-2007
    Location
    Lombard, Illinois
    Posts
    60

    Re: Pivot Table Calculated Item Field Grand Total Not using Formula

    I've uploaded the workbook with a ten days data. What I need is the grand total percent to be 95.15%, not 949.21%.
    Attached Files Attached Files

+ 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. Replies: 0
    Last Post: 10-24-2013, 10:59 AM
  2. Missing Grand Total for a Calculated Field in a Pivot Table
    By Robert Hamilton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2006, 02:20 PM
  3. calculated item does not work in grand total column in Pivot
    By Valerie_NOLA in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 02:35 PM
  4. calculated item does not work in grand total column in Pivot
    By Valerie_NOLA in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 02:30 PM
  5. [SOLVED] Pivot Table Calculated Field (Grand total question)
    By Linda in forum Excel General
    Replies: 5
    Last Post: 08-03-2005, 06: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