I have a chart that is displaying the Monthly Sales of the current fiscal year to the last fiscal year. Now I am making a small table to the side with the actual $ figures of the monthly sales with a column showing the variance of one month this year to the same month last year. Is there an easy way to do this? I tried using the Var function but it doesn't calculate correctly. What I need is to take the amount in the second column (2014) for each month/row and minus the amount in the first column (2013) for the same month/row. Would it be easier to just layout a table with fixed columns and rows and then name the cells and figure it out that way? I'd like to make it as dynamic as possible so I was hoping I could add a total column and then modify the formula to get the calculation I need but I'm not sure how to get that.
Any help would be greatly appreciated!