Forum Discussion

gyanianand's avatar
gyanianand
Cloud Apps
07-06-2023

Add indentation to pivot cell values

Hi Team and Angelina_QBeeQ  I want to add indentation in pivot cell please help: it should be displayed like the below image  
Technology
Angelina_QBeeQ's avatar
Angelina_QBeeQ
ETL
07-06-2023

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
angelina.bulgakova@qbeeq.io
QBeeQ - Gold Implementation and Development Partner