Sum formula in XL Reporter
When I am using XL reporter, I would like to get the sum of the expanding section in the next row. I've tried =sum(ixref(D12,2)) in D11 cell, but it doens't work.
Please kindly help.
A simple solution is put the sum under the expanding section first.
Make another cell on top equal to that sum.
In this way, the formular will work.