Results 1 to 2 of 2

Thread: Summarize/pivot with dates as column headers.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2010
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Summarize/pivot with dates as column headers.

    I have a worksheet that contains dates as some of the headers. When I select Summarize/Pivot, I see Jan282010 in both the Columns to Analyze and Columns to Summarize windows, and not the dates I have on my spreadsheet.

    Is there a way I can see my headers and have it summarize properly. Right now, wheter I chose 1 or all of the Jan282010 references, the summary sheet shows them all as 2/10/2010.Total, and the data on the summary sheet is incorrect.

    .

  2. #2
    Board Regular Easy-XL Support's Avatar
    Join Date
    Nov 2009
    Location
    Ottawa, Canada
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Summarize/pivot with dates as column headers.

    Please send the worksheet to support at easy-xl dot com.

    If the first row of the sheet contains actual data then you should insert a row above it and enter the column names there.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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