Does anyone know if there is a way to hide empty rows in a pivot table. I’ve tried setting the data to undefined where it isn’t applicable, but doesn’t work.
Hello,
As in all data components, the only way to hide the particular rows is to filter them.
As pivot contains both raw data ( accessible as pivot.data ) and aggregated dataset rendered in the table ( pivot.$$("data").data ), the correct way of filtering is
pivot.$$("data").filter( function(obj){ /* filtering logic */ } )
Thanks Nastja