pivot table and multiple "sum of"'s

  • Thread starter Thread starter Stevie
  • Start date Start date
S

Stevie

I didn't use pivot tables much before, so this may seem a silly
question to you. I want to use twice "Sum Of ..." next to eachother.
I'm using the manual configuration method. So maybe what I'm trying to
do is rather difficult this way. If it's easier another way, I'd like
to know.

I'll make clearer what I want using a little example

Sum of French Sum of English
1 5
2 6
2 6
3 7
4 8
5 8

I'm using the pivot table thing in a Windows NT4.0 environment with
Office 2000.

Thanks in advance for your help.
 
Hi
how is your source data organized. Lets assume its organized like the
following:
Topic Language Amount
top1 French 10
top1 English 25
top1 English 5
top2 English 5
top3 French 7
....

you can use set up the pivot table as follows:
Pivot Row: Topic column
Pivot Data: SumOf Amount column
Pivot Column: Language column

The output would look like
French English
top1 10 30
top2 0 5
top3 7 0
 
I'm sorry. I should have been more clear.
In fact I've got two columns of data, like the amount of units you buy
on one hand, and the price to pay on the other hand. The examples I
give are in fact just mere examples.

I want to get two pivot field next to eachother
one "Sum of x", meaning column 1, the other one "Sum of y" meaning
column 2.
I'm not sure it's possible to get those two "sum of's" above a column
in the pivot table, or left of two different rows.

May I ask you to give a rather extensive explanation.
I'm just a newbie regarding pivots.
Any help would be greatly appreciated.
 
Back
Top