Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
BOM Chart - Date | Balance | Change | BOM Chart - Cumul |
07/12/2009 | 311580 | 0.00 | -121440 |
09/12/2009 | 311580 | -21600.00 | -121440 |
11/12/2009 | 289980 | -21600.00 | -99840 |
16/12/2009 | 268380 | 0.00 | -78240 |
20/12/2009 | 268380 | 0.00 | -78240 |
22/12/2009 | 268380 | 0.00 | -78240 |
27/12/2009 | 268380 | 0.00 | -78240 |
Hello,
You can use peek with negative offsets to look starting at the end, i. e.:
would look for last value of Field in TableName or use functions before() and after() in pivot tables.peek('Field', -1, 'TableName')
I'd give a try as well, should your table use always same rder in columns to function Column(No.) where "No." is number of column, i. e.:
Sum(Sales) / Column(4)