Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please note that database contains cumulative figure, however I wish to load the figure non-cumulative form. For eg, in Jan, revenue is 100, in Feb, it is 210 which cotains Jan Figure also. I wish to load 110 as Feb Revenue instead of 210. Please provide script which can be used to create non-cumulative figure while laoding.
Within a sorted (resident) load you could with the functions peek() or previous() access the previous rows and therefore calculate the difference between them - see to how it worked to this example: Peek() vs Previous() – When to Use Each.
- Marcus