Basically all I want to do is sum four data items together and create one
separate total data item.

You could SUM the four values then copy the cell with the formula and Paste
SpecialValues into another cell - or - have a macro do it all for you.

"robjworsley" wrote:

Basically all I want to do is sum four data items together and create one
separate total data item.

Thanks a lot. It was so simple that I feel embarassed that I had to ask lol.
I just used the pivot table menu Formulas... calculated field... SUM
formula.

thanks again

Rob

"bigwheel" wrote:

You could SUM the four values then copy the cell with the formula and Paste
SpecialValues into another cell - or - have a macro do it all for you.

"robjworsley" wrote:

Basically all I want to do is sum four data items together and create one
separate total data item.

Don't ever worry about asking about simple things. What turns out to be
simple always looks difficult before you get an answer. After all, we're all
here to expand our knowledge. Thanks for the feedback

"robjworsley" wrote:

Thanks a lot. It was so simple that I feel embarassed that I had to ask lol.
I just used the pivot table menu Formulas... calculated field... SUM
formula.

thanks again

Rob

"bigwheel" wrote:

You could SUM the four values then copy the cell with the formula and Paste
SpecialValues into another cell - or - have a macro do it all for you.

"robjworsley" wrote:

Basically all I want to do is sum four data items together and create one
separate total data item.