PivotTable Orientation

E

ERR229

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
 
R

Ron Coderre

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
 
E

ERR229

That does it. Thanks!
--
ERR229


Ron Coderre said:
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
Click to expand...
 
Top