+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Calculated Field Showing Differences of Subtotals

  1. #1
    Registered User
    Join Date
    05-24-2016
    Location
    Florida
    MS-Off Ver
    2016
    Posts
    1

    Pivot Table Calculated Field Showing Differences of Subtotals

    Ok, I am missing something simple here or something. I am pretty new to Pivot Tables but they seem to make a lot of sense to me. I have a table pivoted that includes sales data for two fiscal years. I want to compare month to month from these two years for year to date. I get that no problem. I show the five months of our fiscal year and 2015 and 2016 Subtotals perfectly. But I want to add two additional columns that show the difference in the 2015 and 2016 FY Subtotals and then the percentage change between the two years. I can easily add the columns and do the math outside the pivot but that is not what I want because I am doing other things with it. I have tried every combination I can think of and it is just not working. Any help would be appreciated.

    ModSales.jpg
    Attached Images Attached Images

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Pivot Table Calculated Field Showing Differences of Subtotals

    I am not sure if a formula can help you or if the source data has to be played with. Please attach a sample workbook with non-sensitive data.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. calculated field not showing up in pivot table
    By stephme55 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-27-2016, 03:23 AM
  2. [SOLVED] A pivot table field calculated using other field values as fields?
    By chrisf78 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-07-2015, 03:08 AM
  3. [SOLVED] Subtotals for a calculated field within a Pivot table
    By marketshare in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-15-2013, 02:45 AM
  4. Replies: 0
    Last Post: 03-02-2013, 08:15 AM
  5. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  6. Pivot table calculation. Showing differences
    By Richard Flame in forum Excel General
    Replies: 2
    Last Post: 03-26-2007, 05:55 PM
  7. [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

Tags for this Thread

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