+ Reply to Thread
Results 1 to 2 of 2

Multi-Table Pivot Incorrect

  1. #1
    Registered User
    Join Date
    08-28-2015
    Location
    Colorado
    MS-Off Ver
    2013
    Posts
    25

    Unhappy Multi-Table Pivot Incorrect

    After creating a Pivot Table from two tables, when I insert a column with data from Table 2, it does not show the number in the correct row. Instead, it repeats the value in every row down the column.

    1.PNG

    The row highlighted yellow should be the only row containing that number.

    How can I fix this?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Multi-Table Pivot Incorrect

    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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] Incorrect Figure In Pivot Table
    By Hercules1946 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-06-2017, 08:33 AM
  2. Incorrect sort order on Pivot Table
    By bruiser in forum Excel General
    Replies: 10
    Last Post: 03-14-2014, 11:04 AM
  3. [SOLVED] Incorrect data in Pivot table
    By Reedberg in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-16-2013, 09:55 AM
  4. Pivot table sum value incorrect
    By bird is da word in forum Excel General
    Replies: 4
    Last Post: 01-28-2012, 02:27 PM
  5. Pivot table row total INCORRECT
    By Excel Novice805 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-29-2010, 12:11 PM
  6. Pivot Table Calculation Field Incorrect
    By alski in forum Excel General
    Replies: 1
    Last Post: 07-09-2009, 10:10 PM
  7. [SOLVED] Incorrect totals in Pivot Table
    By Jake in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 07:10 PM

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