Thanks for your reply and example.
In sheet 1, you have the states ranked in descending order by sales. I am looking to calculate a different measure, which might be difficult to do. I need to see the overall sales trend over time, represented as a single number.
It's difficult for me to explain, because I do not know how to calculate it. The best analogue I can give is the trend line. For a downward-sloped trend line, I would want to see a negative number; if upward, a positive one. The size of the number would indicate the strength of the trend. The hard part for me is that I want this value to take into account every data point (in this case, months) in my timeline - which I believe is what the trend line does. I need this because we can have cases where the closing numbers are higher than the opening ones - even though the overall trend is downward.
I want to be able to rank my customers by "steepest downward trend", for example.
Please let me know if that explanation makes sense, and thank you for your help!