Viabav sends in a question about creating a particular pivot table. There are a number of challenges in this project. In
Episode 840,you will see how to re-order items along a pivot field, how to removesubtotals from one field, how to arrange multiple date fields to goacross the page, changing the headings from Sum of X to just X, andfilling in blanks with zeroes.
This blog is the video podcast companion to the book,
Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
More...