Hiding totals column from pivot table

Support
#1

I want to hide/remove totals column from the pivot table but didn’t find any suggested method, is there any way?

#3

Hi!

Yes, there is no certain method to hide or remove these columns. But you can use CSS styles as mentioned here: Hide Column and Row Totals · Issue #538 · nicolaskruchten/pivottable · GitHub.
So, your CSS styles will be following:

.pivot-hidden-totalrow {
  thead > tr > th.pvtTotalLabel, .rowTotal, .pvtGrandTotal {
    display: none;
  }
}
.pivot-hidden-totalcol {
  tbody > tr > th.pvtTotalLabel, .colTotal, .pvtGrandTotal {
    display: none;
  }
}

And just add styles to the pivotTable:

pivotTable.addStyleName("pivot-hidden-totalrow");
pivotTable.addStyleName("pivot-hidden-totalcol");
#4

Thank you it works well.