Pivot Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nathan_savidge - 30 Apr 2008 14:33 GMT

Hi,

I have not done pivot tables for a long time, so would be grateful of some
help.

I have the following data:

Name Qty Revenue Include
Nathan 2 1000 1
Steve 3 1500 1
Nathan 1 1000 1

I want a pivot table to appear like :

INCLUDE

NAME QTY REVENUE
Nathan 3 2000
Steve 3 1500

Can anyone help? I am nearly there, but cant get the qty and revenue to be
side by side, they come underneath each other.

Reply to this Message

ryguy7272 - 30 Apr 2008 15:57 GMT

Here ya go:
http://www.freefilehosting.net/download/3gc74

Notice, right-click in the table, click Pivot Table Wizard, click Layout,
and view...

Take a look at these links for more info.
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html

Regards,
Ryan---

Signature

RyGuy

> Hi,
>
[quoted text clipped - 18 lines]
> Can anyone help? I am nearly there, but cant get the qty and revenue to be
> side by side, they come underneath each other.

Reply to this Message

nathan_savidge - 01 May 2008 12:05 GMT

Hi Ryan,

That site (http://www.freefilehosting.net/download/3gc74) is not allowed on
my work internet. Can you download it and email it to me, if i send you my
email.

Thanks

Nathan.

> Here ya go:
> http://www.freefilehosting.net/download/3gc74
[quoted text clipped - 31 lines]
> > Can anyone help? I am nearly there, but cant get the qty and revenue to be
> > side by side, they come underneath each other.

Reply to this Message

Roger Govier - 01 May 2008 09:37 GMT

Hi Nathan

on the PT, just drag your Data button and drop on Total

Signature

Regards
Roger Govier

> Hi,
>
[quoted text clipped - 19 lines]
> be
> side by side, they come underneath each other.

Reply to this Message