I have set of data in powerpivot which can be aggregated by a 'WeekOf' date (where the weeks start on Sundays), e.g. when I create a pivot table or a chart I use the WeekOf date as the row or axis. I also have a slicer based on the WeekOf date.
What I want to do is create pivotables and pivotcharts that show an 8 week trend based on a single slicer selection.
For example, if I select 12/29/2013 in the WeekOf slicer, i would like the corresponding tables and charts to show data for 12/29 and the previous 8 weeks:
Any suggestions on how I could achieve this? Or even some good terminology I could search on?
What I want to do is create pivotables and pivotcharts that show an 8 week trend based on a single slicer selection.
For example, if I select 12/29/2013 in the WeekOf slicer, i would like the corresponding tables and charts to show data for 12/29 and the previous 8 weeks:
- 12/29
- 12/22
- 12/15
- 12/08
- 12/01
- 11/17
- 11/10
Any suggestions on how I could achieve this? Or even some good terminology I could search on?
