Calculation in my Dimension

[#1]

Hi there,

We have various product types (4,5,6,7,8,A,B,C,D,E,F,G,H,I and J)

For a specific chart I only want to display products higher than 5 and smaller than E, thus I want my Dimension to show 6,7,8,A,B,C,and D.

I see in my Dimesions tab there is an option right beneath your used dimensions called "Add Calculated Dimesion..."

Can anyone help me with a formula for my specifcation above that I can use.

I typed it as follows:

if

(Product >'5' and Product<'E')

but it says there is an error in my expession.

Please help.

Thanks!

*R*     

[#2]

if (Product >'5' and Match(Product,'A','B', 'C', 'D'   )  AS DIM

[#3]

Hi,

If product types do not change often, you could do it in a set analysis. See the atached file.

[#4]

Hi there,

If I use your formula it gives me a error in calculation.

Thanks

[kaushiknsolanki]

Hi,

     Dont give as Dim.

     No need to alice it.

     So remove the keyword "As Dim"

Regards,

Kaushik Solanki