Pivot tables, stupid problem

[evaluaciondeproyectos08]

Hi all,
I have this newbies problem trying to format a pivot table in excel
2000. Hope someone can help me,

So I have sales by moths of diferent products and i want to add a
second grand total column, with the percentual totals of each product.
Right now it looks like this:

Name month1 month2 month3 total
prod1 10 12 20 42
prod2 12 12 12 36

And I want it to look like this:

Name month1 month2 month3 total %
prod1 10 12 20 42 54
prod2 12 12 12 36 46

Every time i try to put columns with (column %) i get this percentuals
also for each moth, but when i try to delete them, excel also deletes
the normal columns, so i get nothing in the end.
Thanks a lot just for reading, if someone can help, please do, i'm
completely lost

 

[Herbert Seidenberg]

Here are two solutions, neither of them neat.
Method 1:
Add external data to the Pivot Table.
Con: External data can be overwritten by PT
Con: External data becomes invalid when PT moved
Con: External data must be expanded/contracted to fit changing PT size
Pro: PCT formulas update when selecting/deselecting items.
The PT is located at A3 and might look like this:

Sum of Qty Month
Products Jan Feb Mar Grand Total ProductPCT
apple 29 11 21 61 34.46%
pear 22 30 13 65 36.72%
orange 23 10 18 51 28.81%
Grand Total 74 51 52 177

ProductPCT is the added external data.
Build the formula by dividing 61 by 177 and formatting as percent.
Click on the indicated cells, to get this formula:
=GETPIVOTDATA("Qty",$A$3,"Products","apple")/GETPIVOTDATA("Qty",$A$3)
Replace "apple" with A5, so you can drag the formula down.

Method 2:
Add a calculated field for ProdPCT and two calculated fields
to replace Grand Totals. It might look like this.

Sum of Qty Month
Products Jan Feb Mar ProdTotal ProdPCT
apple 29 11 21 61 34.46%
pear 22 30 13 65 36.72%
orange 23 10 18 51 28.81%
MonthTotal 74 51 52 177 100.00%

It solves some of the Cons of #1, but has its own Cons.
Way more difficult.

 

[juanantonio.abraham]

It's OK I guess i can write a macro that fixes the percentual totals
column to the right of the pivot table. Thanks a lot.

 

[evaluaciondeproyectos08]

Thanks a lot. I guess i can write a macro that fixes the percentual
total column to the right hand side of the pivot table. Thx.