// show pivot grid
  var pivotGrid = new wjOlap.PivotGrid('#pivotGrid', {
    loadedRows: (s, e) => {
      //hide subtotal row initially
      // If current row is the Subtotal row.
      for (let r = 0; r < s.rows.length; r++) {
        let row = s.rows[r];
        if (Object.values(row._ubv).includes('Subtotal')) {
          row.visible = false;
        }
      }
    },
    itemsSource: ng,
  });