Hide Total Column and Row on Pivot Table

Hi,

Is there a way to hide or remove the grand total column and row in a pivot table?

 

Thanks,

Jasmin

9replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Jasmin ,  We've had requests to allow the removal of that total row but we don't have that feature just yet.  I'll make sure we let you know when this feature becomes available!

    Reply Like 1
  • Donna Thanks for the information. Appreciate it!

    Reply Like
  • Donna McGahan  Is there any update on this yet ?

    Reply Like
  • Hi Jasmin Oraa / Rohan Verma - thanks for writing in. You cannot hide the total column or total row on Mode's built-in pivot tables. To achieve this flexibility, consider using a pivot table as a custom visualization:

    https://modeanalytics.com/modeanalytics/reports/ca3017d8eb37

    Once you've implemented the new pivot table in your report, you can hide the totals by following these steps:

    https://github.com/nicolaskruchten/pivottable/wiki/Frequently-Asked-Questions#hiding-totals-in-the-table-renderer

    Hope that helps - please do reach out to our success team via in-product chat or success@modeanalytics.com if we can be of further assistance. Thanks!

    Reply Like
  • Jonathan Krangel Thanks Jonathan. I'm gonna try this.

    Reply Like
  • Jonathan Krangel Thanks, it worked! 🙂

    Reply Like
  • Glad to hear Jasmin Oraa

    Reply Like
  • From all the articles I read here, everyone seems unhappy with the pivot table charting options, or lack of. Some more flexibility to display tabular data is desperately needed IMO. 

    Reply Like
  • Jonathan Krangel your pivot table works great.  Two questions though:

     

    1 - It seems as though the default rounding is to two decimal points.  How do I change the rounding?

    2 - I am building a report and I'm trying to use several of these custom pivot tables.  The problem is they all get grouped at the bottom of my report after all of my text.  I can't write any text in between separate pivot tables.  The text is grouped at the top of the report and the pivot tables are grouped at the bottom after the text.

    I've tried using multiple divs but nothing is working.  Any advice?

    Reply Like
Like1 Follow
  • Status Answered
  • 1 Likes
  • 5 days agoLast active
  • 9Replies
  • 1113Views
  • 7 Following

Create A New Discussion

Share your thoughts