I want to create a rolling column of data in a grid that is dependent on the data of previous columns… its for year over year sales information. If I can figure it out from the screenshot example, I would then like to apply that same logic to the QTY column… so I can show easily the difference between each year’s QTY and Total Sales.
I have included a screen shot of what I am trying to accompish via a Scriptcase Grid.
Even just pointing me in the right direction would be very helpful if you have ANY suggestions.
Thank you!