+ Reply to Thread
Results 1 to 4 of 4

Pivot Table Wrong Data in 1 row only

  1. #1
    Registered User
    Join Date
    02-15-2021
    Location
    dsd
    MS-Off Ver
    2016
    Posts
    2

    Post Pivot Table Wrong Data in 1 row only

    Help me guys!! I've been struggling to find the root cause of this problem. I have a raw data table in RAW DATA worksheet (created a relationship with table in vlookup data (Image 2) to use power pivot), and I have a pivot table OVERALL worksheet that I need to show the payload cycle for March 2021. All but 1 row showed correct data. Payload range 54.6~59.2 (image 3) should have 11 cycles (image 1). But instead, the cycles showed in the (blank) category of the pivot table. However,when I change the rated payload value from 91 to other values from far 91, like 100 and above (MAIN worksheet), the pivot table becomes accurate. I dont know why this happens. Kindly check my macro file in the ZIP file below. This is my first post. Thanks.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by daiichi18; 09-01-2021 at 10:34 AM. Reason: Additional data

  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 Wrong Data in 1 row only

    Is your relationship using the UPPER LIMIT columns?
    Rory

  3. #3
    Registered User
    Join Date
    02-15-2021
    Location
    dsd
    MS-Off Ver
    2016
    Posts
    2

    Re: Pivot Table Wrong Data in 1 row only

    Yes rorya. I am so confused right now. I already included the file int he post. You may check it if you would like to

  4. #4
    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 Wrong Data in 1 row only

    I think it's a floating point error in the conversion used in the relationship (one column being text, the other a decimal number). If you change the formula in the raw data table to:

    =IFERROR(TEXT(INDEX('V-look up data'!$A$2:$E$20,MATCH(TRUE,'V-look up data'!$C$2:$C$20>E3,0),3),"0.000"),"")

    then the data should tie up properly.

+ 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] Pivot Table with 2Million plus records? am i using the data model wrong?
    By adamtzvi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-17-2021, 04:27 PM
  2. Replies: 4
    Last Post: 10-23-2019, 10:31 AM
  3. Pivot Table Showing Wrong data
    By fuerte in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-18-2018, 12:21 PM
  4. Wrong format of the data field deployment of the pivot table.
    By exceldiser in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-18-2015, 11:21 AM
  5. [SOLVED] Double click on filtered value pivot table value will return wrong data
    By macroqmm9 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-11-2013, 11:52 AM
  6. Pivot table showing wrong data (date not month)
    By rushdenx1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2010, 06:59 AM
  7. Pivot Table pagefield returns wrong data when changed with vba
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2010, 03:32 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