Hi -
I;'m wondering if someone could give me a recommendation on this. Can I
combine/pair/link two row labels together.
here is my example... I need to show both the acct# and acct. name in a
Pivot Table. Can I connect them somehow so they can display on the same row,
rather then having them show as a row and sub-row.
I've tried grouping - which doesn't seem to give me what I need. Any
suggestions or recommendations? I'm using Excel 2007.
Thanks in advance for your time and help!!!!
Cindy B

Could you not just concatenate them in a helper column and pivot that
column?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Cindy B" <benedett@brainerd.net> wrote in message
news:6FCE0179-B122-47B3-BD13-189EFF919EC8@microsoft.com...
> Hi -
> I;'m wondering if someone could give me a recommendation on this. Can I
> combine/pair/link two row labels together.
> here is my example... I need to show both the acct# and acct. name in a
> Pivot Table. Can I connect them somehow so they can display on the same
> row,
> rather then having them show as a row and sub-row.
> I've tried grouping - which doesn't seem to give me what I need. Any
> suggestions or recommendations? I'm using Excel 2007.
> Thanks in advance for your time and help!!!!
> Cindy B

On Apr 29, 12:41*pm, Cindy B <bened...@brainerd.net> wrote:
> Hi -
> I;'m wondering if someone could give me a recommendation on this. *Can I
> combine/pair/link two row labels together.
> here is my example... I need to show both the acct# and acct. name in a
> Pivot Table. *Can I connect them somehow so they can display on the samerow,
> rather then having them show as a row and sub-row.
> I've tried grouping - which doesn't seem to give me what I need. *Any
> suggestions or recommendations? *I'm using Excel 2007.
> Thanks in advance for your time and help!!!! * *
> Cindy B

I get my account numbers and account names to appear on the same row
by just not having the account field set to subtotal - as there is a
1:1 relationship between accoutn number and account name this works
fine.

Regards

Chris

Thanks for your reply!
I'm not sure what you mean by a helper column... Would I just create that as
an new column on the spreadsheet, and then that column would be available for
row labeling in the pivot table? I'll try that - and see how if I can get it
to work....

thanks - again...
--
Cindy B


"Bob Phillips" wrote:

> Could you not just concatenate them in a helper column and pivot that
> column?
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Cindy B" <benedett@brainerd.net> wrote in message
> news:6FCE0179-B122-47B3-BD13-189EFF919EC8@microsoft.com...
> > Hi -
> > I;'m wondering if someone could give me a recommendation on this. Can I
> > combine/pair/link two row labels together.
> > here is my example... I need to show both the acct# and acct. name in a
> > Pivot Table. Can I connect them somehow so they can display on the same
> > row,
> > rather then having them show as a row and sub-row.
> > I've tried grouping - which doesn't seem to give me what I need. Any
> > suggestions or recommendations? I'm using Excel 2007.
> > Thanks in advance for your time and help!!!!
> > Cindy B
>
>
>

That worked perfect.. can't believe I didn't think about that!!!!
Thanks for helping me out!!!!
--
Cindy B


"Bob Phillips" wrote:

> Could you not just concatenate them in a helper column and pivot that
> column?
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Cindy B" <benedett@brainerd.net> wrote in message
> news:6FCE0179-B122-47B3-BD13-189EFF919EC8@microsoft.com...
> > Hi -
> > I;'m wondering if someone could give me a recommendation on this. Can I
> > combine/pair/link two row labels together.
> > here is my example... I need to show both the acct# and acct. name in a
> > Pivot Table. Can I connect them somehow so they can display on the same
> > row,
> > rather then having them show as a row and sub-row.
> > I've tried grouping - which doesn't seem to give me what I need. Any
> > suggestions or recommendations? I'm using Excel 2007.
> > Thanks in advance for your time and help!!!!
> > Cindy B
>
>
>