+ Reply to Thread
Results 1 to 4 of 4

CONCATENATEX in Values - Order Problems

  1. #1
    Registered User
    Join Date
    02-24-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    10

    Question CONCATENATEX in Values - Order Problems

    Hey guys so I have a problem with CONCATENATEX in my Pivot. You can see the excel attachment. Basically, the order of the pivot results is wrong.

    in Excel table "PO-HO/2106/62701" has Qty Outstanding "70" but the Pivot results using CONCATENATEX in values fields is "15". How can I make it right?

    my Formulas are:

    =CONCATENATEX(Table1;Table1[Trans. No];"; ")

    and

    =CONCATENATEX(Table1;Table1[Qty Outstanding];"; ")

    Thank you in advance
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,039

    Re: CONCATENATEX in Values - Order Problems

    Please provide a copy of the workbook with your formulae in place so that we can troubleshoot them. This sample book is of no use - sorry.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    02-24-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    10

    Unhappy Re: CONCATENATEX in Values - Order Problems

    the files are too big and I cant post a link

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,039

    Re: CONCATENATEX in Values - Order Problems

    I am not asking to see your real data. Please read the instructions again:

    Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results.
    By realistic we mean a workbook that reflects the real layout/set-up.

+ 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. Replies: 0
    Last Post: 04-21-2021, 03:04 PM
  2. Problem with CONCATENATEX measure in pivot table
    By Jayjay33 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-17-2021, 08:24 PM
  3. [SOLVED] CONCATENATEX and Using Slicer Value in FILTER
    By swong1709 in forum Excel General
    Replies: 5
    Last Post: 11-05-2020, 11:01 PM
  4. [SOLVED] CONCATENATEX formula
    By Yaghoub61 in forum Excel General
    Replies: 3
    Last Post: 03-26-2020, 08:16 AM
  5. [SOLVED] Cumulative SUM of values - in a order specified by a order list 1-10
    By etaf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2015, 03:56 PM
  6. Problems with custom sort order
    By bluphoto in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-11-2008, 06:23 PM
  7. problems doing a lookup because or order
    By nabilqu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2007, 12:15 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