Summing across a Row

[#1]

Can some one help with the expression I need to calculate Expr2, to create the table the user needs to select 1 year.

Dim1 >--> Quarter>--> 1

Dim2 >--> Month/Year >--> Jan-09 | Feb-09 | Mar-09

Expr1 >--> Value 1>--> 10 | 15 | 25

Expr2 >--> Value2>--> 10 | 25 | 50

[deepakk]

hi,

Tyr out the attach application

[#3]

Sorry, maybe I was not clear I'm deriving Expr2 from Expr1

[deepakk]

hi,

You can do it in both ways... Either create at scrip level or fron end.. The current applications contains the front end part also... see the second pivot table.

[#5]

Thanks, but when pivoted so with the Expressions are horizontal as the attached the 'Above' function does not work.

[deepakk · Accepted solution]

hi Chris,

In Such Case use Before function instead of Above.