Pivot: grand totals

  • 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.
 
That will change my reporing format. I cannot do that. But thanks for your
response.
 
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
 
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
Click to expand...
 
Back
Top