Creating a calculated field similar to the following should get the desired outcome:
((lookup(sum([que]), first()+1)-lookup(sum([que]), first()))-1)/(lookup(sum([que]), first()+1))
Once it is placed on the view, right click on it and select Compute using...>ch.
Hope this helps!
Thanks for the reply.
The percentage values are now matching. There are 3 issues that I am trying to fix:
1.) The percentages must be displayed next to only one row of data in the column as attached image
2.) Sometimes the data does not load based on ch column and hence es column is the be used for computation.
3.) We may have only data for 3 rows and is such cases the computation is to be performed based on the es values. Now blank data is shown.
Have attached the images in this reply
Please help fix these and let me know on any details if required.