How can I display multiple variables horizontally in the pivot tab

R

RonLev

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?
--

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
 
R

Ron Coderre

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
 
R

RonLev

To Ron C from Ron L--

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

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

Similar Threads

How can I group and display columns automatically? 3
Using Pivot Table to analyze multiple variables in satisfaction survey 1
how do I format data into columns using a pivot table report? 1
How can I fix a multiplication formula that quit working? 0
I figured out how to do total averages in Pivot Charts! 0
How can I manipulate the way visio displays imported data in a sha 5
Can I AutoSize (or Fit) merged, variable data within a text box? H 8

Top