cancel
Showing results for 
Search instead for 
Did you mean: 

Removing First Row

amelia
9 - Travel Pro
9 - Travel Pro

Hi Sisense Community! I would like to write a script to remove the first row of the pivot table in my widget. I don't want to use an advanced filter, as I already tried that and using a filter affects the rest of the values since I use a DIFFPASTWEEK function. 

Thank you and I would appreciate any thoughts 🙂 

1 REPLY 1

Ophir_Buchman
Sisense Team Member
Sisense Team Member

Hi @amelia 

If you want to remove the contents of this row refer to my article at https://community.sisense.com/t5/build-analytics/pivot-2-0-manipulating-a-pivot-chart/td-p/3589

Use the "metadata.rowIndex" to identify the row number you wish to remove and than change the maxrowheight value of these cells to 0

Similar to my other article at https://community.sisense.com/t5/build-analytics/pivot-2-0-hiding-columns-from-the-display/m-p/3607#...