4 Replies Latest reply on Jan 22, 2012 3:11 PM by Dimitri.B

    Calculated measure to apply only for a certain period

    Michael Nealey

      I have a calculated measure - profit - that I am showing on a time series chart with 3 data points (2009, 2010, 2011).

      I'd like to create a second calculation on profit - let's call it 'profit(2011)' that I can use to sort my time series chart by the profit in 2011, and not across the sum of the 3 periods, as it currently does.

      My date field is set up simply with 1/1/2009 representing 2009 and so on.

      I think I need a 'case' calculation but cannot figure it out...