ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using calculated fields to count unique items in a pivot table (https://www.excelbanter.com/excel-programming/405848-using-calculated-fields-count-unique-items-pivot-table.html)

J.W. Aldridge

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...?



All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com