Total sum in all records using calculated expression

[manideep78]

Dear All,

I have to have the sum of all values in a calculated expression in another column in a chart.

Eg:

Dim --> Month

Expr 1 --> =(10*20)+RowNo()  .This gives me 201,202,203....212 for each month starting from Jan to Dec. and the sum of all of these gives 2478.

Expr 2 --> I want 2478 for each dimension. and this value should be calculated from Expr1.

see below Pic

Please let me know how can I achieve this?

Regards,

Manideep

Message was edited by: Manideep HV

[amit_saini]

Manideep,

I think variable will wok here.

Thanks,

AS

[manideep78]

Hi amit,

Can you please elaborate more?