Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi there,

    I have template of data with pivot table to summarize, and every time I need to group data based on input date, I need to make new pivot which not allowed blank rows, so I can group the data per month or quarterly.

    I am not sure whether this is the way it works or I miss something,

    thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't quite understand. After you group data in a row or column field, you can ungroup them again, so why do you need to create a new pivot table?

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    please find attached file, hope could make this clear.

    I can not group data in Pivot table no 1, but this is format I prepared to be used by someone else which bit difficult to explain how to re-pivot it.

    Once I utilized one of ur formula to indicate name of month in next column, but this case expecting more, having grouping like quarter, or year.

    thanks

    [attachment=86337:Grouping Data on Pivot Table.xls]
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    So why don't you use the second pivot table? You can change the grouping easily:

    [attachment=86339:x.png]

    Attached Images Attached Images
    • File Type: png x.png (4.3 KB, 3 views)

  5. #5
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    So why don't you use the second pivot table? You can change the grouping easily:

    [attachment=86339:x.png]
    Ya, you are right but I need to change source of data, like in summary no.2.

    I can not do that in summary no 1

Posting Permissions

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