This content has been marked as final. Show 2 replies
I have been trying to create a dynamic dimension for a chart that will consistently show 5 weeks regardless of selection.
I can get the chart to show me last 5 weeks from the most recent week no problem, weeks 26, 25, 24, 23 and 22. But when I select a specific week, it will only show one week (obiviously)
What I want to be able to do if possible is if week 22 is selected for example, have the chart display weeks 22, 21, 20, 19 and 18, always having 5 weeks available.
Hope this makes sense. Any help would be greatly appreciated.