Pivot: totals in the next column

  • Thread starter Thread starter Gladiator
  • Start date Start date
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.
 
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
 
Just sent it.

Roger Govier said:
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

.
Click to expand...
 
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.
 
Roger, your second reponse helped a lot and that was what i was looking for.
Thanks again.
 
Back
Top