Hey all,
I've come up against a situation with which I could use some input. I have a worksheet which contains a variety of web campaign measures for a given date. I've created a column which holds (via concatenate) a value for each row so that I can uniquely identify it and find the equivelant value for the same day one week prior. So something like:
PlatformSiteAdvertiserDate Key, Platform, Site, Advertiser, Date, Measure 1, Measure 2, Measure 3
To this, I added a column to calculated the previous week date and created a new key called 'Previous PlatformSiteAdvertiserDate Key'. Then I added three new measure columns to show the previous week data. So now I have:
Previous PlatformSiteAdvertiserDateKey, PlatformSiteAdvertiserDate Key, Platform, Site, Advertiser, Previous Date, Date, Measure 1, Measure 2, Measure 3, Measure 1 (previous), Measure 2 (previous), Measure 3 (previous).
I felt that this would be a good way to do a pivot table that would compare all of the data for a given day with equivelant data from the same day the week prior.
Unfortunately, I've discovered that for any selected day, my previous week comparison columns ONLY contain data where the selected day's data had data from the week before (the campaign was running a week earlier) and does NOT include data where the campaign had ended within the 6 days prior to the selected date.
Have I gone about this all wrong and need to scrap it and start over? Or do you have an idea about how I can also include the data from the previous week's day which is not already being represented in the pivot table (meaning that the particular campaign ended within the 6 days before the selected date)?
Any assistance would be appreciated!
Naggeneen
I've come up against a situation with which I could use some input. I have a worksheet which contains a variety of web campaign measures for a given date. I've created a column which holds (via concatenate) a value for each row so that I can uniquely identify it and find the equivelant value for the same day one week prior. So something like:
PlatformSiteAdvertiserDate Key, Platform, Site, Advertiser, Date, Measure 1, Measure 2, Measure 3
To this, I added a column to calculated the previous week date and created a new key called 'Previous PlatformSiteAdvertiserDate Key'. Then I added three new measure columns to show the previous week data. So now I have:
Previous PlatformSiteAdvertiserDateKey, PlatformSiteAdvertiserDate Key, Platform, Site, Advertiser, Previous Date, Date, Measure 1, Measure 2, Measure 3, Measure 1 (previous), Measure 2 (previous), Measure 3 (previous).
I felt that this would be a good way to do a pivot table that would compare all of the data for a given day with equivelant data from the same day the week prior.
Unfortunately, I've discovered that for any selected day, my previous week comparison columns ONLY contain data where the selected day's data had data from the week before (the campaign was running a week earlier) and does NOT include data where the campaign had ended within the 6 days prior to the selected date.
Have I gone about this all wrong and need to scrap it and start over? Or do you have an idea about how I can also include the data from the previous week's day which is not already being represented in the pivot table (meaning that the particular campaign ended within the 6 days before the selected date)?
Any assistance would be appreciated!
Naggeneen