I have dates in tree view in my Excel-table. Can I get that in my pivot table as well?

**OldManExcellor** · 11-20-2014, 03:59 PM

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?

**Melvinrobb** · 11-20-2014, 04:09 PM

This link should show you how to group dates in a pivot table:
http://chandoo.org/wp/2009/11/17/gro...-pivot-tables/

I have dates in tree view in my Excel-table. Can I get that in my pivot table as well?

LinkBack

Thread Tools

Rate This Thread

Display

I have dates in tree view in my Excel-table. Can I get that in my pivot table as well?

Re: I have dates in tree view in my Excel-table. Can I get that in my pivot table as well?

Thread Information

Users Browsing this Thread

Similar Threads

Convert Pivot Table Tree to XML with 5 child levels

Excel Pivot Table shows zeros from a SQL View hitting an Oracle View via a Linked Server

Excel 2003 view formula within pivot table

[SOLVED] Excel 2003 view formula within pivot table

[SOLVED] Excel 2003 view formula within pivot table

Bookmarks

Bookmarks

Posting Permissions

X vBulletin 4.1.8 Debug Information