1 of 1 people found this helpful
One way you can do this would be to create a calculated field similar to the following:
Window_VAR(sum([Number of Records]), first(), first()+1)
Once it is placed on the view, right click and select Compute Using-->[Date Field]
Hope this helps!
Thank you for replying to my post. I have tried what you suggested but am not sure exactly how to place the calculated field on my view.
Just to make sure that I am explaining this correctly, I am looking to have a 3rd column to show the difference between FY2011 and FY2102.
FY2011 FY2012 Variance
55 53 -2
27 58 31
Then I would change the Variance to show a percentage.
Please let me know if i am explaining it correctly.