Pivot: totals in the next column


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

R

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
 
G

Gladiator

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

.
 
R

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

Advertisements

G

Gladiator

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

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