Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
apologize not trying to do it in a straight table... wabt to do it in a LIST BOX for selection by the end user
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