Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default count not working in pivot table

hello all

I dont know why my counts are not wokring in the pivot table (PT).
Here is the scenario:

I add a field to my PT, field name = On Time
The formula for this field is = 'Days Difference'<0

This works fine I can see the field On Tome = 1 when the Days
Difference is less than 0, BUT the Total On Time at the end of my PT
shows 0, and this is NOT true. It's not giving me the total the actual
count of my On Time field. Any idea why?

by the way the On Time field sometimes has a 0 value, can this be a
problem? I dont think so.

PLeaseeee helppp

Thanks in advance

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 Filter Drop Down not working Jim Excel Discussion (Misc queries) 4 April 3rd 07 02:12 PM
Subtotals not working for Pivot Table kimanne Excel Discussion (Misc queries) 1 November 8th 06 02:09 PM
refresh option of pivot table not working ceejgrl Excel Worksheet Functions 1 October 30th 06 11:28 PM
Working With Pivot Table And External DB Frank Excel Discussion (Misc queries) 0 June 14th 05 08:32 AM
Graph from a PIVOT table: update not working. Please Help! Marcus Excel Discussion (Misc queries) 0 June 7th 05 05:53 PM


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