Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 425
Default Using calculated fields to count unique items in a pivot table

I have a list that summarizes the production of my employees.
The pivot table breaks down their total production by hour.
How do I get a count of the employee names for each hour?
(count unique items)
I can only assume that I will have to enter a calculated field name
and formula...?

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
Specifying the order of pivot table calculated fields/items Rick Excel Discussion (Misc queries) 1 August 10th 08 01:56 AM
How to use pivot table to count repeats of unique fields Susienak Excel Discussion (Misc queries) 4 August 1st 08 11:15 AM
Count unique items in pivot table results BW.Wooster Excel Worksheet Functions 5 April 23rd 07 05:28 PM
How to increase calculations speed in pivot table with calculated fields & items [email protected] Excel Discussion (Misc queries) 0 August 4th 06 09:25 AM
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 05:32 PM


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