[Pivot Table] Pivot Table without total row

[Pivot Table] Pivot Table without total row

  
Forge Component
(6)
Published on 2017-10-05 by Gonçalo Borrêga
6 votes
Published on 2017-10-05 by Gonçalo Borrêga

Hi,

I just wanted to check if there was a way to create a pivot table without showing the total row or total column. Would really appreciate your help if you are able to help me out with this.

Thank you,

Regards,
Archit

Solution

Hi Archit,

As far as I know, only through styling/CSS.

If you add the following CSS to the Screen holding the pivot table you want to hide the totals on, it should work:

thead > tr > th.pvtTotalLabel, .rowTotal, 
tbody > tr > th.pvtTotalLabel, .colTotal, 
.pvtGrandTotal, 
.pvtTotalLabel { 
    display: none; 
}

It could eventually be added as an extra property to the PivotTable block, allowing you to control from outside, but if it is not a common use case that everyone is looking for, maybe this approach is good enough.

Let me know if it works.

Gonçalo

Solution