Skip to content

Summarize data in an Excel Pivot Table

January 5, 2017

Pivot tables are very powerful in summarizing data…..sometimes you may wish to do more than just display the actual numbers. This example shows you how to show % of either column (category) total or the grand total.  In addition, discover how to change the formatting of the numbers.  You will also know how to refresh data – if there is ever a change in the source data, the pivot table will NOT show it until it is refreshed.

Advertisements

From → Excel, Uncategorized

One Comment

Trackbacks & Pingbacks

  1. SutoCom Solutions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: