Not sure if this has been covered, hoping someone can point me in the right direction.
Here's the use case:
- We have media campaigns buys, by website, with a specific start date. End result is a running total for spend to date for each site
- We'll use the running total for each site, and the campaign budget for that site to calculate the % spend against budget to date
- We have an already existing crosstab set up to display campaign performance of each site filtered to display the previous week's performance
- We want to insert the the running total spent and the % spend to date inline with last week's performance
So essentially, the question is can we have data from a different date range in the same crosstab that displays data controlled from it's own date filter?
Thanks in advance for any assistance your guys can provide.
A sample packaged workbook based on sample data that represents your situation (does not need to be real data) combined with exact details on the interaction and results you want, would enable me to help you reach the interaction and results you want.