+ Reply to Thread
Results 1 to 3 of 3

Calculated Item or Field Help

  1. #1
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Calculated Item or Field Help

    I've attached a sample file. On it I have a pivot table showing our vendors 2013 and 2014 sales and I can filter it by Sales Rep. I need the pivot table to also give me the "Dollar +/-" between the two years. I can't get the calculated item or calculated field to work. Can this be done on the pivot table itself? I know I can create a calculation in column D on the "pivot" tab with the formula but I'm trying to automate the task.

    I need to take that data and create one tab per sales rep and list the top 15 "dollar +/-", the bottom 15 "dollar +/-", and want to get this all to update easily when I enter a new months worth of data.

    Thanks for your help.
    Attached Files Attached Files

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Calculated Item or Field Help

    you can add a calculated item using ='2014'-'2013'
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Re: Calculated Item or Field Help

    I wasn't able to do that in my actual file but did it instantly in the my sample file I uploaded here. After some research I was able to make a few changes to my actual file to get it to work. Thanks for your help.

+ 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. Replies: 1
    Last Post: 12-21-2012, 05:40 AM
  3. Replies: 2
    Last Post: 03-06-2009, 11:49 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. [SOLVED] Calculated Field/Item in a Pivot
    By Matt D Francis in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-01-2006, 05: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