How to Create a Pivot Table With Totals at the Top

Have you ever wanted to show the grand totals of a pivot table at the top of the column? There’s no easy way to do it. The following pivot table tutorial shows how to create a pivot table with the totals at the top. Very Clever. Check it out.

Show Grand Total at the Top of a Pivot Table

There’s no setting that allows you to display the grand total at the top of a pivot table. However, with this technique you can use another field that acts as the grand total, and display it at the top.

POSTED BY Pivot Table Guy on Aug 22 under article

Leave a Comment

If you would like to make a comment, please fill out the form below.

You must be logged in to post a comment.

Copyright Just Pivot Tables | Powered by WordPress | Using the GreenTech Theme