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?

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.

"Charp" wrote:

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?