Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Pivot Table No Formula Results on Total

Hello,

I'm trying to calculate the average price per metric tonne, using formula
calculated field, in Excel 2003 pivot table. But when I expand at the country
detail to supplier level it doesn't give me the average price at the total
row.

A particular supplier we will only use until the end of June. This seems to
cause no average price calculation for Q3 and Q4 periods.

Any suggestions to overcome this problem?

Much appreaciated
--
Bozidar Bozic
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
How to do a pivot table with 2 different results Philangr8 Charts and Charting in Excel 1 March 9th 10 09:03 AM
Pivot Table with odd results Rich Young Excel Discussion (Misc queries) 3 October 4th 08 01:33 AM
Duplicate Running Total Grand Total In Pivot Table Mathew P Bennett[_2_] Excel Discussion (Misc queries) 1 August 17th 08 03:13 AM
Showing Pivot Table total on Associated Pivot Chart KenY Excel Discussion (Misc queries) 2 May 18th 07 02:41 PM
keep a running total of my formula results after each (F9) Souvien Excel Discussion (Misc queries) 1 January 23rd 05 01:59 AM


All times are GMT +1. The time now is 05:33 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"