Calculated Dimension

[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

[zagzebski]

apologize not trying to do it in a straight table... wabt to do it in a LIST BOX for selection by the end user

[swuehl]

From the field selection drop down in list box properties, select <Expression> and enter

=if(Left(ZONE,3)='USA','USA','Non USA')

Hope this helps,

Stefan