Nested Grouping (2000 SP3)

Topic

New Reply

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

Reply | Quote

Replies

If you arrange your data like this:

Aggression

Reply | Quote

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

Reply | Quote

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).

Reply | Quote

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).

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

If you arrange your data like this:

Aggression

Reply | Quote