Pivot table expersion

[srinivasa1]

Hi

PFA.Im trying to add and substarct amt1 in another expressions each row can anyone guide me how I can achieve this in best way thanks in advance

[sujeetsingh]

just use peek function in script and you can achieve it

[kumarnatarajan · Accepted solution]

Hi,

Try This one

EX: RangeSum(Above(TOTAL Sum(Amt1),0,RowNo(TOTAL)))