How to store a column value in Dimension

[Former Member]

Hi,

In one of my infoview reports, I have to generate a table and in column 3, need to generate derived data in CH3 column:

CH1 CH2 CH3

R11 R12 =R11/R11

R21 R22 =R21/R11

R31 R32 =R31/R11

The columns Ch1 and Ch2 are generated using Group By clause, and are using aggregate function.

I tried using a seperate query to retrive the data of R11, but not able to use TOP, or Rowcount functions/operators

Is there a way to store such value (R11) in dimension? or is there any way to put a formula for the same?

Please let me know how can i achieve this, TIA.

Regards,

-Vishi

[former_member207342]

cant you simple achieve this by creating objects with following definition.

CH3= Sum/(R11)/Sum(R22)

--Kuldeep

[Former Member]

Well, these values are (R11, R21,R31...) are getting generated on the execution of report.

So I don't know how will I put the formula you are trying to say. Please explain.

Regards.