software

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

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-Proquot;ERR229quot; wrote:

gt; Does anyone know a way to change the orientation of the calculated datain a
gt; PivotTable? For example, instead of :
gt;
gt; Sum of TY 1111111
gt; Sum of LY 2222222
gt;
gt; Have it appear as:
gt;
gt; Sum of TY Sum of LY
gt; 11111111 22222222
gt; --
gt; ERR229

That does it. Thanks!
--
ERR229quot;Ron Coderrequot; wrote:

gt; Try this:
gt; Click and HOLD on the DATA label
gt; Drag it on top of the Totals label....then release the mouse button.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;ERR229quot; wrote:
gt;
gt; gt; Does anyone know a way to change the orientation of the calculated datain a
gt; gt; PivotTable? For example, instead of :
gt; gt;
gt; gt; Sum of TY 1111111
gt; gt; Sum of LY 2222222
gt; gt;
gt; gt; Have it appear as:
gt; gt;
gt; gt; Sum of TY Sum of LY
gt; gt; 11111111 22222222
gt; gt; --
gt; gt; ERR229