+ Reply to Thread
Results 1 to 2 of 2

Calculated Field in Pivot Table

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    peshawar
    MS-Off Ver
    Excel 2007
    Posts
    3

    Calculated Field in Pivot Table

    i have a pivot table in which i want to create a new field via calculated field to subtract Max of Class from Min of sames Class. how to perform this task via Calculated field in pivot table.
    Attached Files Attached Files

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Calculated Field in Pivot Table

    It is not possible with calculated field. You will require additional calculation in source data or use simple formulas adjacent to pivot table.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

+ 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. [SOLVED] Referring to a Sub-Field on Calculated Field Pivot Table Column?
    By figo12 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-27-2014, 02:02 PM
  2. [SOLVED] Pivot Table calculated field
    By rosehill in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-16-2013, 01:26 AM
  3. 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
  4. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  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