Pivot: totals in the next column

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

 

[Roger Govier]

hi Gladiator

Can you show us what your source data looks like?

 

[Gladiator]

Roger, i cannot find a way to send the file as an attachment. Any ideas?

 

[Roger Govier]

Hi
You can send it direct to me if you wish.
roger at technology4u dot co dot uk
Change the at and dots to make valied email address

 

[Gladiator]

Just sent it.

Hi
You can send it direct to me if you wish.
roger at technology4u dot co dot uk
Change the at and dots to make valied email address
--
Regards
Roger Govier

.

 

[Roger Govier]

HI

Just returned it.
although the data was different to that which you showed as an example,
it was just a question of moving the Year field to the column area.

I also wrote some more efficient code for you to Hide / Show rows on
your source data sheet.

 

[Gladiator]

Roger, your second reponse helped a lot and that was what i was looking for.
Thanks again.