Hi, I have a subtable in my details view, I need to get the last value on a particular column within the given range, just like the hlookup function in Excel.
Example on the image attached:
I need a formula to get the last value on a particular column.
Ex. 4th Quarter for year 2017 = 51,469.72
Please help…Thank you very much.