Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Nested Grouping (2000 SP3)

    Is there any way to create nested groupings using VB in Excel? I have grouped ParameterA which is in Col A, but I now want to group by ParameterB (ColB) without losing the ParameterA grouping. E.g.

    Aggression
    Complete
    Ongoing
    Anxiety
    Complete
    Ongoing

    Each ParameterB will have a number (variable) of records, and there will be a variable number of ParameterA's.

    Thanks for any assistance.

    Kiwi

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nested Grouping (2000 SP3)

    If you arrange your data like this:

    <table border=1><tr><td valign=bottom>Aggression</td><td valign=bottom>
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nested Grouping (2000 SP3)

    Thanks for the speedy response. If I am trying to present text, rather than summarize a lot of data, is there a way of doing this without merging fields before making a pivot table? E.g. P1, P2, F3&F4&F5&F6 .... (I have ignored the 'linking' text required for this example).

    It appears that you are limited to 5 row fields in Excel 2000 (may be more in higher versions?), which does not give me all the information I need.

    I am really trying to find a work-around for failure of our set-up to overcome a problem with truncation of large fields in an Access report when exporting to Excel - copying and pasting a table from a query seems to work much better, but still requires formatting.

    Many thanks,

    Kiwi

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nested Grouping (2000 SP3)

    Are you aware that a pivot table can be based on a query directly (check out the first screen of the PT wizard, it says "External data source" as one of its options).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Nested Grouping (2000 SP3)

    I don't understand the question or problem. COuld you explain it differently or attach a representative dataset with what you would like to see from it?

    Steve

Posting Permissions

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