pivot grouping

B

boris

Already have one set of groupings, and now have added
another list of data. Need to incorporate that data
(which only has the "sublevel" of data right now) into
the higher level grouping. So now, the new data shows up
in the grouping, but it basically creates its own group
for each piece of data (since it hasn't been grouped
yet). If it makes it any clearer, the sublevel is a
number of aging days. The grouping is for sets of aging
days (<30, 30-60-60-90, etc.). So what's happened is the
first set of data is showing only at the grouped level,
and when I add the new data, I get the groups I started
and a new group for each new data point (446 days, 231
days, etc.). The only way I have figured out to regroup
them all together is to show the detail of the old
grouping (the actual days), show the detail of the new,
individual groups (also actual days), then regroup them,
then rename them AGAIN into the same group names as old.
Hoping there is a way to effectively drag/drop the new
pieces into the old groups. Hope that makes sense and
someone has the answer. Thanks.

Boris
 
G

Guest

If you drag the items you want to group adjacent to the already grouped
items, select them all and group them they will be added to the group.
 
G

Guest

unfortunately that does not do it, as what it does is
create a new group another level up. I want it to be
created at the same level. I think the solution I was
using earlier seems to be the only one.
Basically, "opening" the old group to show all the
underlying pieces, "opening" the new group to show the one
piece that is underlying, then grouping that lower level
set together, renaming it again as the old group. Thought
someone had a better way, but oh well.

Thx for trying.
Boris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top