That does it. Thanks!
--
ERR229


"Ron Coderre" wrote:

Try this:
Click and HOLD on the DATA label
Drag it on top of the Totals label....then release the mouse button.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"ERR229" wrote:

Does anyone know a way to change the orientation of the calculated datain a
PivotTable? For example, instead of :

Sum of TY 1111111
Sum of LY 2222222

Have it appear as:

Sum of TY Sum of LY
11111111 22222222
--
ERR229