Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 193
Default HELP PLEASE! - APPLYING A % COLUMN TO A PIVOT TABLE RESULT

Hi,

I have just run a pivot table (for the 1st time!) with the following
variables: Item, Factory, Order Qty, Exp Production Date. The table lists the
number of orders for our products which works great however, I now want to
add in a % column so it lists each product's percentage of the total products
on order.

Can anyone advise me how I can do this?
--
Thanks so much

Pete
EXCEL 2003, WINXP SP2, 1 GIG RAM,

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 193
Default HELP PLEASE! - APPLYING A % COLUMN TO A PIVOT TABLE RESULT

Hi please disregard this post as I have now figured it out .
--
Pete


"Pete" wrote:

Hi,

I have just run a pivot table (for the 1st time!) with the following
variables: Item, Factory, Order Qty, Exp Production Date. The table lists the
number of orders for our products which works great however, I now want to
add in a % column so it lists each product's percentage of the total products
on order.

Can anyone advise me how I can do this?
--
Thanks so much

Pete
EXCEL 2003, WINXP SP2, 1 GIG RAM,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Pivot Table - how do I add a column? ajnmx Excel Worksheet Functions 1 November 25th 06 04:17 PM
Currency to Text mytipi Excel Worksheet Functions 1 February 21st 06 11:43 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
pivot table sort entries that don't yet appear in table rachael Excel Discussion (Misc queries) 11 September 19th 05 11:29 PM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"