ExcelBanter - PivotTable Orientation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - PivotTable Orientation (https://www.excelbanter.com/excel-discussion-misc-queries/63948-pivottable-orientation.html)

ERR229

PivotTable Orientation

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

Ron Coderre

PivotTable Orientation

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

ERR229

PivotTable Orientation

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

All times are GMT +1. The time now is 03:19 AM.