Pivot Table to count how many left and joined each month

Are you still using Excel 2010?

Perfect. This is a great example of how Power Pivot makes this easy.

Format your source data as a table, then load to the Data Model. I prefer to do this via Power Query, named "Member Data":

Please Login or Register  to view this content.

In Power Pivot, add a new Date Table. Note that you should not create any relationships to your Member Data table.

Now add some measures to your model:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Finally, create your pivot table using required fields:

Capture.PNG

See attached workbook for worked example.