doubt in before function

[sibideepak]

Hi all,

I have an pivot table with data shown in image

but what i actually want is i want add another expression that sums before column ie

Q1                 Q2                       Q3               Q4

val1 val2    val1 val2           val1 val2         val1  val2

6      6         7      13              8      21           5       26

Thanks in advance

[sibideepak]

is anyone to reply !!!

[CELAMBARASAN]

PFA

I hope it will help you

[tresesco]

val1=Sum(AmtField)

val2=RangeSum(Before(Sum(AmtField),0,2))

[sibideepak]

Hi ,

In both peoples answer ..im not getting it..

here is my sample file

[CELAMBARASAN]

Sorry !

Exp2 shoud be =Alt(Before(Exp2), 0) + Exp1

[sibideepak]

Hi ,

is this achievable from script or using variable because i dont want it in front end