Above function on Expression

[rajni_batra]

Hi Folks,

I am trying to calculate Opening and closing balance in a straight table. But stuck at getting above row value.

Please help here.

[robert_mika]

Change to pivot Table and use

above(sum([Opening Balance])+Sum([Debit Amount])-Sum([Credit Amount]))

Above works on dimension so if you have 3 dimension it will give value based on all dimensions

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[rajni_batra]

Thanks a ton Gysbert!!!