Analytics Software

Hi All,

Can we use running sum of one column in calculation of another column in OBIEE answers??? If possible how can we implement?

For example :

Col1---Col2--Col3(running sum of col2)---- Col4 (col3/10)
1------ 10-----10---------------------------------------1
2------ 30---- 40---------------------------------------4
3------ 0------ 40---------------------------------------4
4------15---- 55---------------------------------------5.5
5------ 0------ 55---------------------------------------5.5
6------ 20---- 75---------------------------------------7.5



In col3 i need running sum of col2 and in col4 i need data from col3 after applying some calculation.. Is this possible??
These ( col3 and col4) calculations have to be done in pivot view because I need to apply filter condition on some other column after that I need result as above...

We can use "Display as Running Sum" in pivot view but after that we can't apply any logic on those values.
And also in Criteria tab we can use RSUM to get col3. But after applying filter (In pivot need to filter data based on other column in section tab) only I need to apply running sum...

Any other possibility to achieve the same???

(Note: Just to seperate data column wise i used ------)

Thanks in Advance,
Regards,
Sindhu