示例说明
透视分析添加排序列。效果图如下:
设置方法
宏类型
类型 | 对象 | 事件 |
ClientSide | INSIGHT | onRenderTable |
宏代码
function main(insight) { var mainTable = insight.grid.mainTable; //获取表格对象 var columnFieldSize = insight.grid.columnFieldList.length; //获取列区个数 var measureFieldSize = insight.grid.measureFieldList.length; //获取度量值个数 var headSize = columnFieldSize > 0 ? (measureFieldSize > 1 ? columnFieldSize + 1 : columnFieldSize) : 1; var idx = 0; var rowSpan = 1; var trObj = mainTable.rows[0]; while (trObj != null) { if (headSize > 1) { headSize--; var firstChild = trObj.firstChild; var blankTd = firstChild.cloneNode(true); trObj.insertBefore(blankTd, firstChild); } else if (rowSpan > 1) { rowSpan--; } else { var firstChild = trObj.firstChild; var blankTd = firstChild.cloneNode(true); if (idx == 0) { var span = blankTd.firstChild.firstChild.nextSibling; span.innerHTML = "序号";//设置排序的表格表头 } else { blankTd.align = 'center'; blankTd.innerHTML = "" + idx; } idx++; trObj.insertBefore(blankTd, firstChild); rowSpan = firstChild.rowSpan; } trObj = trObj.nextSibling; } } |
附件:透视分析排序.xml