+ Reply to Thread
Results 1 to 3 of 3

Using a data field twice in the 'Rows' section of a pivot table.

  1. #1
    cdavidson
    Guest

    Using a data field twice in the 'Rows' section of a pivot table.

    In my source data, I have a 'Date' field. In my pivot table, I want to use
    the 'Date' field twice:

    * Once to sort by 'Year' (i.e. simply changing the format to 'YYYY')

    * And a second time to sort by 'Month' (i.e. simply changing the format to
    'MMMM')

    Can I do this without the requirement of adding fields to my source data?

    Thanks.

  2. #2
    Dave Peterson
    Guest

    Re: Using a data field twice in the 'Rows' section of a pivot table.

    Is this a row field?

    How about just grouping them by year and month?

    rightclick on the date field and
    choose group and show detail|group by months and years.



    cdavidson wrote:
    >
    > In my source data, I have a 'Date' field. In my pivot table, I want to use
    > the 'Date' field twice:
    >
    > * Once to sort by 'Year' (i.e. simply changing the format to 'YYYY')
    >
    > * And a second time to sort by 'Month' (i.e. simply changing the format to
    > 'MMMM')
    >
    > Can I do this without the requirement of adding fields to my source data?
    >
    > Thanks.


    --

    Dave Peterson

  3. #3
    cdavidson
    Guest

    Re: Using a data field twice in the 'Rows' section of a pivot tabl

    Thanks. Didn't know you could use the 'Group' function that way.



    "Dave Peterson" wrote:

    > Is this a row field?
    >
    > How about just grouping them by year and month?
    >
    > rightclick on the date field and
    > choose group and show detail|group by months and years.
    >
    >
    >
    > cdavidson wrote:
    > >
    > > In my source data, I have a 'Date' field. In my pivot table, I want to use
    > > the 'Date' field twice:
    > >
    > > * Once to sort by 'Year' (i.e. simply changing the format to 'YYYY')
    > >
    > > * And a second time to sort by 'Month' (i.e. simply changing the format to
    > > 'MMMM')
    > >
    > > Can I do this without the requirement of adding fields to my source data?
    > >
    > > Thanks.

    >
    > --
    >
    > Dave Peterson
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1