Results 1 to 5 of 5

Pivot Table Calculated Field

Threaded View

  1. 12-10-2013, 05:47 AM #1
    andrewc
    andrewc is offline
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    812

    Pivot Table Calculated Field

    Hi,

    I have created a Pivot Table using data that's in a range assigned as a Table.

    When setting up the PT I inserted a few calculated fields that used data in the associated Table. The calculated fields returned the correct results but when I tried to edit the formulae in the calculated field (PivotTable Tools -> Options -> Fields, Items & Sets -> Calculated Field) I can't see the formulae.

    Can someone please tell me how to edit the formulae?

    Thanks
    Last edited by andrewc; 12-10-2013 at 06:46 AM.
    Reply With QuoteRegister To Reply
« 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 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
  2. Calculated Field in Pivot Table Based on One Summed Field and one Counted Field
    By ddgacic in forum Excel General
    Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  3. Pivot Table Calculated Field Sum
    By NMullis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2009, 11:30 AM
  4. [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
  5. Pivot Table Calculated field
    By bjorgens in forum Excel General
    Replies: 0
    Last Post: 05-05-2005, 07:36 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