+ Reply to Thread
Results 1 to 2 of 2

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

  1. 11-20-2014, 03:59 PM #1
    OldManExcellor
    OldManExcellor is offline
    Forum Contributor
    Join Date
    05-30-2011
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    107

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

    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?
    Reply With QuoteRegister To Reply
  2. 11-20-2014, 04:09 PM #2
    Melvinrobb
    Melvinrobb is offline
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: I have dates in tree view in my Excel-table. Can I get that in my pivot table 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.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert Pivot Table Tree to XML with 5 child levels
    By Neo444 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2013, 03:45 PM
  2. Excel Pivot Table shows zeros from a SQL View hitting an Oracle View via a Linked Server
    By JesseDW in forum Excel General
    Replies: 3
    Last Post: 08-31-2012, 12:40 PM
  3. Excel 2003 view formula within pivot table
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 11:05 AM
  4. [SOLVED] Excel 2003 view formula within pivot table
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] Excel 2003 view formula within pivot table
    By jpjejmcc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1