jqGrid not showing yDimension when numeric values

jqGrid fails to render data columns in the below scenario - all I get is the 'Type' column.

Note that the values for year are all numeric - if I change the values to 'Year1', 'Year2' etc, the grid works correctly, but I will be receiving raw numeric values for this field.

        jQuery("#grid").jqGrid('jqPivot',
        mydata,
		// pivot options 
		{
			xDimension: [
                        { dataName: 'Type', width: 170, editable: false, key: true}
			],

			yDimension: [{ dataName: 'Year' }],

			aggregates: [
                       { member: 'Amount', aggregator: 'sum', editable: true, width: 90, align: 'right', formatter: 'currency', formatoptions: { decimalPlaces: 2 } }
                       //{ member: 'Amount', aggregator: 'sum', editable: true, width: 90, edittype: 'custom', editoptions: { custom_element: myelem, custom_value: myvalue }, width: 90, align: 'right', formatter: 'currency', formatoptions: { decimalPlaces: 2 } }
			    
			]
		},
        // grid options
        {
            width: 780,
            cellEdit: true,
            cellsubmit: 'clientArray',
            rowNum: 150
        });


    var mydata = [
          { "Type": "10", "Year": "1", "Amount": "1008.0000" },
          { "Type": "200", "Year": "2", "Amount": "140.0000" },
          { "Type": "300", "Year": "3", "Amount": "130.0000" },
          { "Type": "400", "Year": "4", "Amount": "0000"},
          { "Type": "500", "Year": "5", "Amount": "0000"},
          { "Type": "600", "Year": "6", "Amount": "0000" },
          { "Type": "600", "Year": "7", "Amount": "0000" },
    ];

Open in new window

sailing_12Asked:
Who is Participating?
 
sailing_12Connect With a Mentor Author Commented:
Created a dictionary array to get around this.
0
 
leakim971PluritechnicianCommented:
look fine for me : http://jsfiddle.net/hoyjrr0t/1/
0
 
sailing_12Author Commented:
Hmm - I see that. Still not working for me here.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
leakim971PluritechnicianCommented:
time to share a link to your page.
0
 
sailing_12Author Commented:
can't - internal app.
0
 
sailing_12Author Commented:
Unable to reproduce the issue and provide a solution outside internal environment.
0
All Courses

From novice to tech pro — start learning today.