+ Reply to Thread
Results 1 to 3 of 3

Pivot Table - Calculated Item adds unnecessary rows

  1. #1
    Registered User
    Join Date
    07-09-2020
    Location
    Utah
    MS-Off Ver
    365
    Posts
    3

    Pivot Table - Calculated Item adds unnecessary rows

    The attached file contains pivot table with the calculated item "Remaining +/(-)". Without the calculated item everything evaluates correctly but with the calculated item, the pivot table creates unnecessary rows. Adding a field to the pivot table further multiplies the issue. How can this be fixed?
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Pivot Table - Calculated Item adds unnecessary rows

    The simplest way would be to add two new columns to your source table for Budget and Actual. Then create a calculated field in your pivot table instead of the calculated item. You could also load the data to the data model and create three measures there to achieve the same thing.
    Rory

  3. #3
    Registered User
    Join Date
    07-09-2020
    Location
    Utah
    MS-Off Ver
    365
    Posts
    3

    Re: Pivot Table - Calculated Item adds unnecessary rows

    Thanks! Adding two different columns in the source table and using calculated field achieves what I need and its a rather easy workaround.

    Looks to me like the highlighted calculated item issue is something Microsoft should fix. I don't see the application of what the calculated item is doing.

+ 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. Creating calculated field and calculated item into a pivot table
    By dvpe in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-12-2019, 12:15 PM
  2. Pivot table with Calculated Item with Two Rows Label
    By vinaynaran in forum Excel General
    Replies: 1
    Last Post: 07-29-2016, 12:06 PM
  3. Calculated Item in Pivot table
    By Centre13 in forum Excel General
    Replies: 5
    Last Post: 03-04-2014, 10:17 AM
  4. Replies: 1
    Last Post: 10-06-2009, 04:01 AM
  5. Add calculated item to pivot table
    By tony0710 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-08-2009, 10:10 AM
  6. Replies: 3
    Last Post: 06-06-2006, 12:10 AM
  7. Pivot Table Calculated Item
    By jerry in forum Excel General
    Replies: 6
    Last Post: 10-26-2005, 03:05 PM

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