2 Replies Latest reply: Jul 21, 2017 2:28 AM by Arvind Patil RSS

    Dynamic Dimension for chart to show last 5 weeks from selected Week

    c_buick222 c_buick222

      Hi all,


      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.