Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Filter Drop Down not working | Excel Discussion (Misc queries) | |||
Subtotals not working for Pivot Table | Excel Discussion (Misc queries) | |||
refresh option of pivot table not working | Excel Worksheet Functions | |||
Working With Pivot Table And External DB | Excel Discussion (Misc queries) | |||
Graph from a PIVOT table: update not working. Please Help! | Excel Discussion (Misc queries) |