How do I combine four data items into one in a Pivot Table?

R

robjworsley

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

bigwheel

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

robjworsley

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
 
B

bigwheel

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
 
Top