sequence columns order in a pivot

Webix JS
1

Hi all,
in a pivot table I have 3 columns (col_1 (sum), col_2 (sum), col_3 (avg) )
How to keep this order? when I click to “apply” the order of columns becomes:
col_3 (avg), col_1 (sum), col_2 (sum)
Many thanks

2

Hi,

Could you please share the code of your Pivot (its structure) and describe the action you perform within the configuration windiw before clicking the ‘Apply’ button?

I could not reproduce the issue, columns order remains unchanged from my side.

3

Hi Helga,
I made a small video about this issue that you can get here:

https://drive.google.com/file/d/0B3IiPTXvD-r7d1ZNeTJRWmlDUGc/view?usp=sharing

4

webix.ready(function(){
grida = webix.ui({
container: pivot_id,
id: pivot_id,
view: “pivot”,
readonly: true,
readonlyTitle: “My Title”,
footer: true,
resizeColumn:true,
resizeRow:true,
autowidth:true,
autoheight:true,
adjust: “data”,
autoConfig:true,
structure: {
rows: [“agency”],
columns: [“customer”],
values: [{ name: “amount”, operation: “sum”, format: webix.i18n.numberFormat}],
filters:[]
}
});
//add avg
grida.addOperation(“avg”, function(data) {
var sum = 0;
for (var i = 0; i < data.length; i++) {
if( data[i] )
sum += window.parseFloat(data[i], 10);
}
return data.length?(sum/data.length):0;
});

grida.parse(pivotData);

});

5

I see, thank you.

We have already fixed the issue in our dev build. The fix will be available in the nearest release (February 23rd).

If you have a support subscription and need the fix ASAP, please contact support@webix.com.