Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Antony
 
Posts: n/a
Default retirning count values from calcualted fields

I have built a pivot table that returns a count for both the actual and
planned number of courses completed during a given month. However, now want
to create a calculated field that retruns the difference between the count of
actual and count of planned completions. However as the original data on
which the numbers of completions are counted is in date format I can only get
the pivot table to return a calcualtion of the difference between the dates.

In short what I'm trying to get is

Calculated field= count ('actual complettions') - count ('planned
completions')

rather than Calculated field = 'actual completions' - 'planned completions'

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 do I count values across multiple columns? [email protected] Excel Worksheet Functions 4 March 21st 06 11:13 PM
Count unique values among duplicates in a subtotal range jcpotwor Excel Discussion (Misc queries) 2 January 12th 06 01:29 PM
count and display unique values joe Excel Worksheet Functions 2 December 19th 05 01:11 AM
Count on multiple values with duplicate rows Carla Excel Worksheet Functions 1 November 22nd 05 09:25 PM
Count number of values Mary Excel Worksheet Functions 1 October 4th 05 09:00 PM


All times are GMT +1. The time now is 07:49 AM.

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"