Change sorting order of date filed in pivot column

Hi tsaho8 ,

The following script could work for your case. 
Depending on the number of rows and columns, you might have to tweak the index number it to make it work. 
Assuming a simple pivot table, with just one row dimension and one column dimension:

widget.on("buildquery", function(se,ev) {
	ev.query.metadata[1].jaql["sort"]="desc";
})

 

Please let me know if this works for you : )

Always here to help,
Helena from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner