3 Replies Latest reply: Oct 14, 2013 10:37 AM by mayilvahanan ramasamy RSS

    Filtering on calculated dimension OR expression

    Steve Zagzebski

      I hate the following chart:

       

      Group IDDivision IDContract
        Effective Year
      Revenue
      1A20091,000
      2B20092,000
      3C20093,000
      4D20094,000
      5E20105,000
      6F20106,000
      7G20107,000
      8H20118,000
      9I20119,000
      10J201110,000

       

      "Contract Effective Year" is an expression. It is :

      min(year([Contract_Date]))

       

      What is the best way to select only 2010?   This seems like it should be simple but I am always running into situations where I want to filter on a calculated dimension or an expression.