+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Calculated Item Error

  1. 03-17-2014, 09:54 PM #1
    DPaton
    DPaton is offline
    Registered User
    Join Date
    01-29-2014
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    13

    Pivot Table Calculated Item Error

    Hi everyone

    I have a calculated item in a pivot table, the formula being =IF(OR('1Q13'=0,'1Q14'=0),0,('1Q14'-'1Q13')/'1Q13'). The formula works fine for each row except for the total row where the calculation result is wrong. Also, when you click on each cell in the rows of the calculated item column the formula is displayed in the formula bar, but the row total only displays a hard number, which is wrong. Any help would be enormously appreciated!

    Cheers

    Derek
    Reply With QuoteRegister To Reply
  2. 03-18-2014, 12:55 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Pivot Table Calculated Item Error

    Refer the attached file for details
    Attached Files Attached Files


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 03-18-2014, 08:47 PM #3
    DPaton
    DPaton is offline
    Registered User
    Join Date
    01-29-2014
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Pivot Table Calculated Item Error

    Thanks Sixthsense, much appreciated.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculated Item in Pivot table
    By Centre13 in forum Excel General
    Replies: 5
    Last Post: 03-04-2014, 10:17 AM
  2. Add calculated item to pivot table
    By tony0710 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-08-2009, 10:10 AM
  3. [SOLVED] pivot table formulas for calculated field or calculated item
    By Vicky in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 12:10 AM
  4. [SOLVED] Pivot Table Calculated Item
    By jerry in forum Excel General
    Replies: 6
    Last Post: 10-26-2005, 03:05 PM
  5. Pivot Table with calculated Item
    By Greg Doucette in forum Excel General
    Replies: 0
    Last Post: 04-12-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1