Good afternoon,
I am trying to figure out a formula that will help me calculate the quarter over quarter differential. I have attahced a small example of the data however, what you dont see in my small example file is that the data is in a pivot table and I am performing the calculations in the cells adjacent. I dont think that should make a difference but wanted to mention it.
I need this formula to calculate the differential both positive and negative. So if I had no issue 1 in the first quarter but 2 in the 2nd qaurter then I had a 200% increase. However if I had 0 issue 1's in the 3rd qaurter then we had a 200% drop in instances.
Anyone have any ideas?
Thanks,
Brad
Bookmarks