Pivot table

2077delta · May 8th, 2002, 10:55 AM

I would like the grand total column on a pivot table to appear as the first column of data not as the last. Is there a way to move the grand total column or do I have to set up a calculated field?

Mark W. · May 8th, 2002, 11:17 AM

> Is there a way to move the grand total
> column

No.

> ...do I have to set up a calculated field?

Calculated Items.

2077delta · May 8th, 2002, 12:29 PM

That's what I thought. Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 10:55 AM	#1
2077delta Board Regular Join Date: Feb 2002 Posts: 217	I would like the grand total column on a pivot table to appear as the first column of data not as the last. Is there a way to move the grand total column or do I have to set up a calculated field?

May 8th, 2002, 11:17 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	> Is there a way to move the grand total > column No. > ...do I have to set up a calculated field? Calculated Items.

May 8th, 2002, 12:29 PM	#3
2077delta Board Regular Join Date: Feb 2002 Posts: 217	That's what I thought. Thanks.