Identifying New/Terminated Data in Aggregate Pivot Table Data Source

[aizquierdo]

Hi there!

In a nutshell, I am trying to determine when accounts go "live" and when they are terminated using an aggregate data source that is provided in a pivot table view.

Here is an example of what i see when the account goes live (imgur link):

Imgur: The most awesome images on the Internet

and then when it gets terminated, there is nothing else to generate, so no additional records are displayed like this account ending on 4/8/15 (imgur link):

Imgur: The most awesome images on the Internet

So i would like to create a table/view/etc that will show me a list of what went live (new data in the pivot table) and what was cancelled (no longer generating data in pivot table) when i refresh the data source to update with previous day's data.

*These two things would be a bonus
- If it can output what day the account terminated
- If it can pick up a drop in activity (for example, 50% less activity than the day prior)

I assume i need a complex IF formula, but could really use someone's help (if this is possible).

Thank you so much!