Create the caliculate Dimension

[ravindraa]

Hi all,

  I have struk one place Plase give  any suggession to me to resolve my problem

My requirment is we have data existed like below in data base.

Name                    ModelType        value

OldRenolds           OLD_R               10

OldRenolds_PP    OLD_R_PP          15

NewRenolds          NEW_R              20

Balpen                   Balpen               50

***OldRenolds->means  OLD_R + OLD_R_PP

****Renolds -> means OLD_R + OLD_R_PP+NEW_R

In out put need to diplay like below.

ModelType            Value

OldRenolds            10

NewRenolds            20

Balpen                    50

Renolds                  45

to get above out put i have tried like below

If(ModelType='NEW_R','NewRenolds',

if(ModelType='Balpen','Balpen',

if(ModelType='OLD_R' or 'OLD_R_PP' ,'OldRenolds',

if(ModelType='OLD_R' or 'OLD_R_PP'  or 'NEW_R','Renolds')))) as ModelType_New

In the ModelYype_New  dimension i am not getting the *Renolds* Fiels and its value

i am getting all fields and thier values but rest of Renolds Field and its value.

Please give me any suggession to get this.

[ravindraa]

Hi Tresesco,

  Thanks you very much for giving the help.