2 Replies Latest reply on Feb 19, 2013 2:53 PM by Brooke Bondur

    Side by side comparsion of years with relative week filter

    Brooke Bondur

      I'm trying to create a bar chart view that displays sales Amount in each year but filtered to display the last N weeks from today.  I have the layout and data filtered to display full year Amount side by side.  I now need a relative date filter to display Amount for the last 6 weeks, i.e. compare the sum of weeks 3 through 8 for 2013 to the sum of weeks 3 through 8 for 2012.  I've found solutions in the Forum that comes close but doesn't get me exactly what I need.  I have attached a sample workbook with a sample of my data.  We're using V7 but I have V8 beta also.  Thanks for any help.