Results 1 to 2 of 2

Thread: Pivot Grid - Expand Levels

  1. #1
    Sencha Premium Member
    Join Date
    Sep 2015
    Posts
    9

    Default Pivot Grid - Expand Levels

    Hi,

    would i need to build a pivot grid but the leftaxis data hasn't always the same depth, like:

    Code:
    leftAxis: [{
                        dataIndex: 'la1',
                        header: 'Subject',
                    }, {
                        dataIndex: 'la2',
                        header: 'Subject'
                    }, {
                        dataIndex: 'la3',
                        header: 'Subject'
                    }, {
                        dataIndex: 'la4',
                        header: 'Subject'
                    }, {
                        dataIndex: 'la5',
                        header: 'Subject'
                    }]
    and the json store:
    Code:
    fields: [{
            name: 'la1',
            type: 'string'
        }, {
            name: 'la2',
            type: 'string'
        }, {
            name: 'la3',
            type: 'string'
        }, {
            name: 'la4',
            type: 'string'
        }, {
            name: 'la5',
            type: 'string'
        }, {
            name: 'CostHour',
            type: 'float'
        }],
    
    
        data: [
            {
    
    
                la1: 'Dept. A',
                la2: 'Dept. A.1',
                la3: 'Dept. Mngr. Mike',
                la4: 'Project X1',
                la5: 'User A',
                CostHour1: 105
    
    
            },
            {
                la1: 'Dept. A',
                la2: 'Dept. A.1',
                la3: 'Dept. Mngr. Mike',
                la4: 'Project X1',
                la5: 'User B',
                CostHour: 105
            },
            {
    
    
                la1: 'Dept. B',
                la2: 'Dept. B.1',
                la3: 'Dept. Mngr. Mike',
                la4: 'Project X1',
                la5: 'User A',
                CostHour1: 105
    
    
            },
            {
                la1: 'Dept. B',
                // la2: 'Dept. B.1',
                // la3: 'Dept. Mngr. Mike',
                // la4: 'Project X2',
                // la5: 'User B',
                la2: 'Project X2',
                la3: 'User C',
                la4: null,
                la5: null,
                CostHour: 105
            }
        ]
    so it will result in this:
    Screen Shot 2017-04-04 at 14.33.41.png

    So, my question now is, how can i remove the rows that will have "(blank)" values and disable the expand, in this case, in "User C" row?

    Is it possible?
    Thanks

  2. #2
    Sencha Premium User
    Join Date
    Dec 2009
    Location
    Iasi, Romania
    Posts
    159
    Answers
    9

    Default

    You can't do that

Similar Threads

  1. How to access two levels of data in grid model?
    By xjscrafter in forum Ext: Q&A
    Replies: 3
    Last Post: 31 Jan 2014, 7:37 AM
  2. Multiple levels of grouping in grouped grid?
    By jfizer in forum Ext 2.x: Help & Discussion
    Replies: 8
    Last Post: 28 Jul 2008, 1:37 AM
  3. Grid with multiple expand-levels
    By bjorngregersen in forum Ext 2.x: Help & Discussion
    Replies: 0
    Last Post: 14 Dec 2007, 5:35 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
  •