Pivot: grand totals

[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.

 

[Eduardo]

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

 

[Gladiator]

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

 

[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

 

[Gladiator]

Thanks. Then how do i combine them together?

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