Posted to microsoft.public.excel.misc

derwood[_2_] derwood[_2_] is offline

external usenet poster

Posts: 4

add column for percentage o total

in pivottabes i have a row of names with the relevant customer spend shown
alongside. there is the sum total shown at the end.. how can i create a
column that reflects each customer spend as a percentage of the total....
thanks in anticipation

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
Percentage total may not exceed 100	The Fool on the Hill	Excel Discussion (Misc queries)	5	September 6th 07 03:26 PM
Total Revenue Percentage	Willing to learn	Excel Discussion (Misc queries)	5	July 19th 07 08:32 PM
Percentage Discount Total	mdj101	Excel Discussion (Misc queries)	1	May 18th 06 04:33 PM
Percentage Discount Total	mdj101	Excel Discussion (Misc queries)	2	May 18th 06 04:20 PM
a number as a percentage out of a total	solskinn	Excel Worksheet Functions	3	December 8th 04 06:23 PM

All times are GMT +1. The time now is 02:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us