Realigning Pivot Data


J

James

Hello

At the moment I have three lots of data in my pivot table are they are shown
in the same row i.e. one on top of the other.

Sum of Allocation 1,257
Sum of Sold 999
Sum of % Sold 79%


Does anyone know how I can show the data by columns instead?


Thanks
 
Ad

Advertisements

J

Jim Thomlinson

The nice thing about pivot tables is that in general things are easy to move
around. The heading above your 3 Data elements is a grey drop down with the
word Data in it. Grab the box and drag it from it's current position in the
left hand column and drop along the top in the appropriate row. As you drag
the Data box you will get an I-beam indicator letting you see where it is
going to position itself...
 
Ad

Advertisements

J

James

Got it thanks Jim. Knew you could move column and row fields just didn't know
it with data!

Thanks again

James.
 

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