i have a pivot table that I had to paste special and want to sum a

[Guest]

I did a paste special on a pivot table to add additional columns and I need
to subtotal on those additional columns with every change in each pivot table
total. VAlues or amounts will need to be input fro Apr, May & June.

For instance:

Name Jan Feb Mar Apr May June
Apple 10 10 10
1 1 1
2 2 2
Apple Total 13 13 13 0
Orange 5 5 5
Orange Total 5 5 5
Peach 3 3 3
12 12 12
1 1 1
2 2 2
23 23 23
4 4 4
Peach Total 45 45 45


Any suggestions?

 

[Guest]

When you did the paste special you didn't select formulas. Go back and copy
March Row. then paste special using formula only. formating will be
preserved.