aizquierdo
New Member
- Joined
- Mar 3, 2016
- Messages
- 1
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!
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!