4 Replies Latest reply: Apr 1, 2013 2:10 PM by ajdavis1 RSS

    If statements in Set Analysis

      I'm using Set Analysis to ensure the x-axis in a bar chart ignores the Year filter (so I can show YOY comparisons). 

       

      Here is the formula I'm using:  SUM ({<YEAR=>} [CUSTOMER BALANCE]) / 1,000,000

       

      Since the most recent data included is as of Feb 2013, whenever a later month is selected the latest year shown is 2012.  However I'd like the last bar to still show 2013 with the most recent data of that year available. 

       

      So let's say the month of December is selected.  I would like all previous years (2008 - 2012) to show December information, but I would like 2013 to still show on the chart using February's data.  Is this possible?

       

      Thanks