i need to create a bar chart that shows Sales by Month for the last 5 quarters, using the selected quarter as the end date on the graph. I have Month, Quarter and Year as separate fields. Quarter and Year are included in the selection criteria. How do I create where the bar chart is not just limited to the selected Quarter and Year? for example, if q2 and 2016 are selected, I would like the bar chart to show Sales by Month for the period April 2015 - June 2016 (q2 2015 - q2 2016). I have reviewed the document Set Analysis for Rolling Periods but could not get my graph to work. Thanks.
