Posted to microsoft.public.excel.programming

JohnB

external usenet poster

Posts: 53

PivotTables and xlPercentOfTotal

so Hi All
Is it possible to have pivottable which has a Grand Total column and in the
column to the right have the same numbers shown as percentages. All in one
pivottable. So in effect there are 2 Grand Total Columns, 1 with numbers and
the other with percentages. I can only do currently using a 2nd pivottable.

If its possible then how?

TIA
johnb

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PivotTables	Gerry Verschuuren	Excel Discussion (Misc queries)	4	October 25th 07 01:12 AM
PivotTables	KerryK	Excel Discussion (Misc queries)	2	October 8th 07 07:06 PM
New to Pivottables- need help	coal_miner	Charts and Charting in Excel	1	June 6th 05 06:48 PM
Drill Down in PivotTables	doco	Excel Discussion (Misc queries)	2	February 3rd 05 11:46 PM
PivotTables/VBA	jngi[_3_]	Excel Programming	2	September 24th 04 12:27 PM

All times are GMT +1. The time now is 08:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us