LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Changing Pivot Field Display Order

    Employee
    Posted 09-27-2012 07:39

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Cindy

    I need some help on a Pivot-Data to Names. I am needing to order the column headings alphabetically, and I can't figure out how? It is alphabetized, from column 2-9--but column 1, which begins with an "L" is out of order. Wierd. Thanks! CC


  • 2.  RE: Changing Pivot Field Display Order

    Employee
    Posted 10-03-2012 11:32

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    Without seeing your data, I am just going to guess, but I suspect it might be one of two issues. Is there a space or whitespace in front of the "L", so it is first? You should trim before you sort. The other issue might be a case issue. Is everything lowercase but the word beginning with "L"? If so, you need to toUpper or toLower before you sort. So for your sort expression, try 'field'.trim().toUpper(), I suspect that will help.

    Cheers
    Rich