2 Replies Latest reply: Feb 1, 2013 11:29 AM by Stefan Wühl RSS

    Calculated Dimension

    Steve Zagzebski

      I am struggling creating a simlpe calculated dimension in a straight table

       

      Basically all I want is a list box that would take the "ZONE" field below and create a "SEGMENT" field that would have the following criteria  ..if begins with "USA" than "USA", otherwise "NON-USA"

       

      ZONE

      USA - NE

      USA - SW

      USA - SE

      CANADA - W

      CANADA - E

      MEXICO - W

      MEXICO - E

       

      What my calculated dimension (in a list box) would be:

       

      SEGMENT

      USA

      NON - USA