Add row numbers to pivot rows

Hi irismaessen 

I think you can achieve your end result with the following workaround.

First, duplicate the first row dimension, and rename it to Row for example.

Then, add the following script to your widget.

It will then overwrite the cell values with their row number.

widget.transformPivot({
   type: ['member']
}, handler);

function handler(metadata, cell) {
	
	if (metadata.type=='member'&&metadata.index == 0&& metadata.rowIndex >0) { //only changes for first column, value rows.
     cell.content = metadata.rowIndex; 
	 
    }
}

Here is an example of the end result:

Please let me know if this works for you : )

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