Results 1 to 2 of 2

Thread: Ext Pivot grid column sorting.

  1. #1

    Default Ext Pivot grid column sorting.

    Hi Team,

    I use licensed Ext JS Version 6.0.1 with pivot feature. In pivot grid, I have top axis columns for Month-Year and columns looks like below, it comes in below order :

    "Jan 2006","Feb 2006","Mar 2005","Mar 2006","Apr 2005","Apr 2006","May 2005","May 2006","Jun 2005","Jun 2006","Jul 2005","Jul 2006","Aug 2005","Aug 2006","Sep 2005","Sep 2006","Oct 2005","Nov 2005","Dec 2005"

    Actually columns should come in below order

    "Mar 2005","Apr 2005","May 2005","Jun 2005","Jul 2005","Aug 2005","Sep 2005","Oct 2005","Nov 2005","Dec 2005","Jan 2006","Feb 2006","Mar 2006","Apr 2006","May 2006","Jun 2006","Jul 2006","Aug 2006","Sep 2006"

    The reason is that it consider the Month-Year as string and use natural ordering for the top axis columns.

    is there any way we can arrange columns in proper sort order?

    Your help will be much appreciated.


  2. #2
    Sencha Premium User
    Join Date
    Dec 2009
    Iasi, Romania


    On that top axis dimension you can define the "sortIndex" to point to a field on the model that has numeric values that can be sorted properly.

Similar Threads

  1. Pivot grid integration with sparkline Widget Column ?
    By vbhandarkar in forum Sencha Ext JS Q&A
    Replies: 3
    Last Post: 17 Aug 2016, 8:22 AM
  2. Custom column/row sorting in a Pivot Grid
    By sareko in forum Ext 3.x: Help & Discussion
    Replies: 2
    Last Post: 24 Jan 2014, 12:04 AM
  3. pivot grid general column
    By aramaki in forum Ext 3.x: Help & Discussion
    Replies: 1
    Last Post: 18 Nov 2011, 12:09 PM
  4. Pivot grid column alignment issue
    By raj_plays in forum Ext 3.x: Help & Discussion
    Replies: 0
    Last Post: 25 Feb 2011, 12:23 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts