+ Reply to Thread
Results 1 to 2 of 2

Referring to a Sub-Field on Calculated Field Pivot Table Column?

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    59

    Lightbulb Referring to a Sub-Field on Calculated Field Pivot Table Column?

    Hello people:

    I am currently looking forward into adding a Calculated Field Column into an existing pivot table, the issue I am having is that I see the Table fields to enter them on the new calculated column formula, but is it possible to list or see the sub-fields? For example one Field has two subfields, and I need to multiply each subfield by a different number.

    Thanks very much!

  2. #2
    Registered User
    Join Date
    04-09-2013
    Location
    Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Referring to a Sub-Field on Calculated Field Pivot Table Column?

    I have been researching without success, but I am thinking about alternative solutions:

    a) Is it possible to add a sub-field as as a main field list for a pivot table?

    b) Is it possible to a add a a calculated column on a pivot table based on cell name or any custom name?

    Thanks!

+ 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: 03-02-2013, 08:15 AM
  2. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  3. Adding new calculated/column field to pivot table
    By MARYAN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2010, 05:34 AM
  4. Replies: 3
    Last Post: 02-23-2009, 10:07 AM
  5. [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

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