This can be done by using a table calculation, using a formula similar to the following:
(ZN(SUM([Number of Records])) - LOOKUP(ZN(SUM([Number of Records])), -1)) / ABS(LOOKUP(ZN(SUM([Number of Records])), -1))
Then, place this on the view. It will be necessary to edit how the table calculation is being computed--it will probably need an advanced compute.
Hope this helps a bit!
I think lookup function looks up +/-n rows according to offset point. But I don't have a regular table to use a determined "n". The pair row is somewhere there in the data.
I think it may only look up the pair row by using a "for loop", but is there any available "for loop"? If there is, will it be efficient to use here such a code like a macro?