Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kim
 
Posts: n/a
Default Calculated fields-Pivot tables


Hello to all you excel Gods,

I have created a pivot table to show the total gross and average gross of
sold items. I have included the amount of stock items and on order items.

My problem is that my average gross is showing for a total of the sold
new,sold used , stock and on order items as my worksheet has a seperate
column for sold, stock and on order.

Therefore I thought "Calculated fields" would work. I does for one instance
but I can't seem to have more than one calculated field show on the pivot
table.

I wanted to show a field for the total sold new and used stock then another
showing the total gross divided by a total of new and used sold.

Sorry for the essay.

Gross New Sold Used Sold Stock On order
5721.82 7 0 2 0
10569.21 29 3 3 9

Average gross I want to be Gross divided by New sold plus Used sold.

Thanks in advance
  #2   Report Post  
Junior Member
 
Posts: 23
Default

Send me a copy of the xls and a description of your expectations.
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 Tables - Variance and % Variance fields CraigS Excel Discussion (Misc queries) 5 January 6th 05 01:22 AM
How to change default page setup for pivot tables? bobs Excel Discussion (Misc queries) 1 January 5th 05 10:42 PM
Pivot Tables, calculated fields Excel GuRu Excel Discussion (Misc queries) 1 December 21st 04 01:08 AM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 06:39 AM
Excel 2002 -> Problem with calculated fields in Pivottable H. Riewert Excel Discussion (Misc queries) 0 December 7th 04 10:33 AM


All times are GMT +1. The time now is 10:45 AM.

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

About Us

"It's about Microsoft Excel"