Take the Log Contact in Column and data Field in Pivot Table
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vincent Torralbes
Sent: Saturday, July 16, 2011 9:11 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Calculating distinct events
I have a table where I maintain a log of every contact event I make with my
customers. In a Pivot table, I'm trying to return and calculate the first
contact event made by unique ID. When I pivot by ID and dump in "Log
Contact", it sums up all the contacts. If I use the Max function, then it
doe
