+ Reply to Thread
Results 1 to 2 of 2

How was 'grouping' created in this excel pivot table?

  1. #1
    Forum Contributor
    Join Date
    02-04-2009
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    113

    How was 'grouping' created in this excel pivot table?

    Hello,
    I was researching an issue i am having trying to round off a time data column, and came across an old post which I found helpful, but unfortunately cannot find again. Fortunately though, I had downloaded attached file that the forum moderator submitted, which I have reattached here.
    How was he able to add the 'Sales' to both the values field AND the 'Row Labels' field?
    Secondly, when you right click on the row labels column in the pivot table, and click on 'Group', how did he get this grouping feature that allows you to group by different intervals?
    Thanks,
    Nathan
    Attached Files Attached Files
    Last edited by nmss18; 06-05-2012 at 03:34 PM.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: How was 'grouping' created in this excel pivot table?

    just drag the field to both areas. the intervals are not different (they are all 5) so I'm not sure what you mean?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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