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 🙂
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#M931
