How can I calculate difference between sales values for different quarters, per client?
Every quarter I have to enter the total sales for that quarter for each client. I would like to compare this to the previous quarter on a per client basis and have searched on the forum but can't find anything. How can I do this please? I am calculating the quarter name eg "2012 Q2" from the relevant date field at the end of each quarter but don't know how to make FMP calculate:
Sales 2012 Q2 - Sales 2012 Q1
Sales 2012 Q1 - Sales 2011 Q4
How do I identify which exact record FMP should take? It would be great if FMP always took the most recent quarter and compared it to the one immediately preceding it, or with zero if nothing is there.