I have an Excel-table where one of the columns is dates. When I click on the column filter I get the wonderful dates tree view: SNAG-0000.png I have created a pivottable based on that Excel-table. In the pivot table I don't get the same dates tree view: SNAG-0001.png Can I somehow get that dates tree view into my pivottable as well?
This link should show you how to group dates in a pivot table: http://chandoo.org/wp/2009/11/17/gro...-pivot-tables/
Please click the * icon below if I have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks