Add indentation to pivot cell values

[gyanianand]

Hi Team and @Angelina_QBeeQ 

I want to add indentation in pivot cell please help:

it should be displayed like the below image

[Angelina_QBeeQ]

Hi @gyanianand ,
Check the next script for your case:

widget.transformPivot(
	{},
  function (metadata, cell) {
    if (metadata.colIndex == 0 && metadata.rowIndex >= 1) {
	cell.content = '\u00A0'+cell.content
    }
  }
);

The script will indent values from the first column in the table.

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