Skip to Content (Press Enter)
UserImage.jpg
Archit Yadav
108Views
1Comments
Solved
[Pivot Table - Traditional] Pivot Table without total row
Question
Forge
pivot-table
Web icon
Pivot Table - Traditional (O11)
Forge asset 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

0
0
31 Jul 2018
Copy Link
2016-11-21 23-23-05
Gonçalo Borrêga
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

1
0
31 Jul 2018
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.