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:
I have created a pivottable based on that Excel-table. In the pivot table I don't get the same dates tree view:
Can I somehow get that dates tree view into my pivottable as well?