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

 

1 Reply

Replies have been turned off for this discussion
  • 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