ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HELP PLEASE! - APPLYING A % COLUMN TO A PIVOT TABLE RESULT (https://www.excelbanter.com/excel-discussion-misc-queries/129200-help-please-applying-%25-column-pivot-table-result.html)

Pete

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,


Pete

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,



All times are GMT +1. The time now is 09:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com