How to Create a Roll up by Month Filter in an Excel Pivot Table





The interactive transcript could not be loaded.



Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 9, 2012

A viewer asked for my help to create a "Roll Up" Hierarchy by Month for Filtering a Pivot Table.

He like the new "Roll Up by Month" Filters in Excel 2007 - 2010 Tables but is frustrated that this does not exist "naturally" in his Pivot Table.

Before I show my viewer how to solve his problem, I take two minutes to demonstrate the power of the new "Natural Language" Date Filters that were introduced in Excel 2007.

To solve the problem for my viewer, I group the Date Field by Date, Month and Year. Now, when you filter the new "virtual" Month Field, you get the "roll up" by Month Filter that my viewer was searching for in a Pivot Table.

I invite you to learn more about the focused tutorials that I offer at my secure online shopping website - http://shop.thecompanyrocks.com

Danny Rocks
The Company Rocks

  • Category

  • License

    • Standard YouTube License


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...