Oracle Analytics Server (OAS) (MOSC) READ-ONLY

MOSC Banner

how to show diff between two row in another column in obiee

edited Oct 27, 2014 10:00AM in Oracle Analytics Server (OAS) (MOSC) READ-ONLY 1 commentAnswered

Hi ,

I have Below is the requirement :

Y1

Y2

X1

100

0

X2

200

100

X3

400

200

FORMULA

Y2X1= 0

Y2X2=Y1X2 –Y1X1

Y2X3=Y1X3 – Y1X2

1.      Y3 is calculated column

2.      first row of y3 should always be 0

3.      2nd row onwards ex : 2nd row : Y2X2=Y1X2 –Y1X1  3rd row : Y2X3=Y1X3 – Y1X2

Note : All columns are associated with time period .

Any help would be greatly appreciated.

Thanks,

Manish Kumar

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center