Pivot: grand totals


G

Gladiator

Hi all, i need your help for the below table:

ITEMS YEAR YRLY_TOT GRAND_TOT
2008 $10
1. ITEM1 2009 $20 $60
2010 $30
2008 $10
2. ITEM2 2009 $30 $80
2010 $40
2008 $20
3. ITEM3 2009 $30 $90
2010 $40

Each item has yearly totals (column YRLY_TOT). I want column GRAND_TOT to
show total of all three years for each item ( i guess the three cells should
be merged, just like they are n column ITEMS). I tried to use Pivot table but
it would not give me the result i want in column GRAND_TOT. Instead it breaks
down by year instead of sumerizing yearly total for each item. How do i get
Pivot to show me the result i want? Or any ideas on how to get the result?
Thanks.
 
Ad

Advertisements

E

Eduardo

Hi,
Move the year to columns, that will give you the result you are looking for
 
G

Gladiator

That will change my reporing format. I cannot do that. But thanks for your
response.
 
E

Eduardo

Hi,
In that case can you create another pivot table below that one and just
change this 2nd one to get the results as you need
 
Ad

Advertisements

G

Gladiator

Thanks. Then how do i combine them together?

Eduardo said:
Hi,
In that case can you create another pivot table below that one and just
change this 2nd one to get the results as you need
 

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