+ Reply to Thread
Results 1 to 2 of 2

Problem encountered when adding calculated item into pivot tabe

  1. #1
    Registered User
    Join Date
    07-31-2016
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    1

    Problem encountered when adding calculated item into pivot tabe

    An extract of my source file is attached Source file_Pivot table.PNG

    Pivot table was created with:

    Row Labels: Region/Name
    Column Labels: Version
    Data: Sum of the values

    A calculated item was added to find the variance between FY1415 and FY1516. When this calculated item is added, the pivot table rows were populated with all the rows, e.g. Region EU should be displaying Station 5 and 6 only but now, Station 1 to 4 get populated into the Pivot Table. See sample of the Pivot Table below.

    Would like to know how to get around this issue? I would like to have the flexibility of adding the calculated item but not the unnecessary rows. Thanks,

    Pivot table.PNG

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Problem encountered when adding calculated item into pivot tabe

    Please attach a sample of your actual workbook to make it easier to work on a solution. Remember to remove/replace any sensitive data before uploading the file.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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] Creating a formula in a pivot table while using another calculated item in the pivot
    By mvhs1073933 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-10-2015, 12:44 PM
  2. Adding a calculated item to a pivot table - problem encountered
    By Jimmy Newman in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-23-2012, 08:35 AM
  3. Need help with a calculated item in a pivot
    By thedon_1 in forum Excel General
    Replies: 2
    Last Post: 02-25-2012, 06:11 PM
  4. Calculated Item in Pivot Tables problem
    By kyrgyzstanart in forum Excel General
    Replies: 5
    Last Post: 09-30-2009, 04:23 PM
  5. Replies: 0
    Last Post: 08-09-2006, 03:40 AM
  6. Pivot Table: calculated item problem
    By vba_intern5 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2006, 01:45 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

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