How can I display multiple variables horizontally in the pivot tab

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RonLev - 15 Jun 2006 16:02 GMT

Hi everyone--

When you enter multiple analysis variables into the pivot table layout the
results always display vertically (with all the variables stacked in one
column), but my client wants to see the results splayed out horizontally
(with each variable in a column). Is there a way to do this?

Signature

For example,

You get this Pivottable normally:

Product Data
Brand A DataVarA
DataVarB
DataVarC
Brand B DataVarA
DataVarB
DataVarC

But I need this format instead:

Product DataA DataB DataC
Brand A DataVarA DataVarB DataVarC
Brand B DataVarA DataVarB DataVarC

Ron Lev

RonLev

Reply to this Message

Ron Coderre - 15 Jun 2006 16:43 GMT

Your example doesn't present much to go on, but let's see if I'm guessing
correctly. I think this might work for you:

Click and HOLD on the DATA heading
Drag it on top of the TOTAL heading
Release the heading

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> Hi everyone--
>
> When you enter multiple analysis variables into the pivot table layout the
> results always display vertically (with all the variables stacked in one
> column), but my client wants to see the results splayed out horizontally
> (with each variable in a column). Is there a way to do this?

Reply to this Message

RonLev - 15 Jun 2006 16:50 GMT

To Ron C from Ron L--

Beautiful. Exactly what I needed. (Need I say that I couldn't find it
anywhere on F1?)

Signature

RonLev

> Your example doesn't present much to go on, but let's see if I'm guessing
> correctly. I think this might work for you:
[quoted text clipped - 16 lines]
> > column), but my client wants to see the results splayed out horizontally
> > (with each variable in a column). Is there a way to do this?

Reply to this Message