I have some data as such:
User Date
001 1/1/2000
002 1/25/2000
003 2/2/2005
004 2/5/2005
005 12/24/2008
I would like to find out, in each month, how many unique users are present?
So in my case, there would be 2 users present for Jan 2000, 2 users for Feb 2005, and 1 user for Dec 2008.
Towards solving this, I have tried using a PivotTable, however, I can't find the appropriate way to group the data by month. So I suspect I need to use the equation bar, but I'm not sure how to use a Group By function.