Pivot Tip 5 - How to lay data totals side-by-side. by David Carter

If you put two items into the DATA area, the pivot table defaults to show one item under the other. If you want to see them side by side, drag and drop with the blue brick thingie.

There doesn't seem to be an official name that describes this blue thing. Anyhow, have a practice to see how it works.

Practice Session
In the previous sessions you have been asked to save the practice database pivot_practice.xls on your own machine. If you HAVE done this, open it now and click onto the pivot worksheet.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments
Richard Willis's picture

Try No. 9 !

Richard Willis | | Permalink

One of the alternative Pivot Table formats (No. 9 in my version) displays multiple data columns side-by-side.