Create a dimension with sales range

[manozpph]

I need to Create a dimension with sales range between

a. 0<= Sales < 5,000

b. 5,000 <= Sales <10,000 etc

Can Some one help me  to write a condition on Sales.

Thanks in Advance,

[ashfaq_haseeb]

Hi,

You need to use class() function

Regards

ASHFAQ

[#3]

Hi,

Use Class function like this

Dimension=Class(Sales,5000,'Sales',0)

Regards,

Vivek

[jagan]

Hi,

Check this link hope it helps you.

Class() with different sizes

Regards,

Jagan.

[MayilVahanan]

Hi

Class function satisfy ur requirement.

Try something like this

Class(Sales,5000,'Sales')