I found an interesting “how-to” guide to Excel 2007 Pivot Table. It is a sample chapter from the Pivot Table Data Crunching for Microsoft Office Excel 2007 book. Probably not all the described feature are available in a Pivot Table attached to an Analysis Services cube, but it definitely worths the read.

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2007/04/24/an-useful-guide-to-excel-2007-pivot-table.aspx