Also divided by 2 products. In order to create this report I need the following fields:
Revenue, Number of shipments, weight, products. Is there a way to create groups based on measures? I need to break the revenue figures by the ranges included in the table (>$1000,>$500, etc).
Omar -
If you wanted to create these groups within your universe, you would need to create a dimension flag off of the measure using a decode sign function. (This is assuming you are using Oracle.) The object sql would look like:
Thank you very much Shawn, I had a problem, when I defined this variable as a measure it worked perfectly, but breaks can’t be used in measures, then I changed it to a dimension but the formula didn’t recognize the values. This is the formula I used:
= Si Entre (0,249) Entonces “< $250” SiNo Si Entre (250,499) Entonces “> $250” SiNo Si Entre (500,1000) Entonces “> $500” SiNo Si Entre (1000,1000000) Entonces “> $1000” SiNo “NA”
Si = If
Entre = Between
Entonces = Then
SiNo = If not
When I change the variable to a dimension just the NA is shown, what can be wrong?
Thanks
Omar
LEVEN, SHAWN L (SBCSI) wrote:
Is there a way to create groups based on measures? I need to break the revenue figures by the ranges included in the table (>$1000,>$500, etc).
Omar,
You could create a variable that incorporates If/Then/Else logic for the different categories you want. For example:
= If >(1000) Then “>$1000” Else If Between (500,1000) Then “>$500” Else etc etc