Pivot Grid Column Order

[Prasad]

I am using Pivot Grid to display "Jan to Dec" columns.  Unfortunately, the column order is not maintained.  I am getting random column order for each refresh/filter.  Is there a way to control the column order?

[jarry]

Please show an example with some sample data to demonstrate your issue.

[Prasad]

Sorry for the late reply.

I could not attach an image.  I tried to reproduce in jsfiddle, but didn't manage to make it work.  But I believe you could help me by looking at the code.  Thank you.

https://jsfiddle.net/zgxege1w/24/

[jarry]

Please refer to http://jsfiddle.net/zgxege1w/25/

[Prasad]

Wow, jsfiddle is working.  [I didn't expect <style> tag to be reversed]


Coming back to the original request,  Is it possible to correct the order of column in ascending?  Jul-16 followed by Dec-16.  Appreciate your help. 

[jarry]

You have to sort your data according to your custom logic before loading into pivotgrid.

Code:

data.sort(function(r1,r2){
	...
});
$('#pg').pivotgrid({
	data: data
	...
});

[Prasad]

Thanks a lot.  Saved my day

http://jsfiddle.net/zgxege1w/35/