Many people know about Pivot Tables now and they know how powerful they can be. In my up and coming book, however, I do point out one or two of the limitations of the Pivot Table when trying to set up a calculated field. Calculated fields can cause problems when there is duplication of data. Don’t worry, even though you will find it difficult to find the solution to this problem in books and on the web, my book’s got it!

On a happier note, there is a lot more to the Pivot Table than meets the eye. Did you know you can get a Pivot Table automatically to set up a running total column for you. You can also get a Pivot Table to do these for you automatically too:

  • % of column
  • %of row
  • difference from
  • % of difference from
  • and a few more

In the next day or two you will find a brief review of how to do this in Excel 2007 on my book’s sister web site, http://www.excelmaster.co.uk. That site is growing, getting busier, getting smarter … waiting for you!

Please visit often to see what’s happening in Excel 2007.

Duncan

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: