Filter on a Range of Values

• Jonathan Mallia

  SSCertifiable

  Points: 5192

  More actions

  May 18, 2012 at 2:51 am

  #256651

  Hi all,

  I have a report where the user can select year values (for ex 2008, 2009, 2010, 2011). I also have a chart where I only want to show only the last 3 values of the years against a measure, therefore showing 2009 - 2011.. Is there a way to filter using a range of values? If not any workaround?

  Thanks in advance!

  Jon

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  May 18, 2012 at 7:08 am

  #1489651

  How about a filter on the chart of something like

  WHERE Year > @YearParameter - 3