we have a new initiative at work and the powers that be would like to see an activity report each week. this will be a simple enough this week minus last week count across three segments. I wonder what anyone else has done in this space. I have begun to create a report file for each week such that each file will contain four tabs (one for each segment of the campaign and one extra on which I will pivot the segments to get a total). Each of these files will be in exactly the same format with tab names the same.
I was then going to create a Weekly Report File that would link back to each week's summary tab (the extra one) and display the summary pivots for each week. In this Weekly Report File, a second tab would have on it the difference between the latest two weeks, which would be the Activity Report.
while this will work, there is a lot of pfaffing about importing each new week and then changing the Activity report parameters to target the latest two weeks.
really hoping for some suggestions.
I was then going to create a Weekly Report File that would link back to each week's summary tab (the extra one) and display the summary pivots for each week. In this Weekly Report File, a second tab would have on it the difference between the latest two weeks, which would be the Activity Report.
while this will work, there is a lot of pfaffing about importing each new week and then changing the Activity report parameters to target the latest two weeks.
really hoping for some suggestions.