I'm analysing a data set that was sent to me looking similar to below table. There are 2 key things I want to obtain (and more after I could play with it):
which item is critical (highest cost) for each year? This is something I could generate for each year separately on a column graph (better suggestions?)
The trend for each iteam over the years. Now since the years are column names, I have troubles generating a graph for this. I don't want to manually update the data table to have years where Items' names are now. Is there an easy way for this? Of course, the data table I have is way bigger and more complex than this.
In addition, I will appreciate any suggestions for studying this type of data. I think there must be a way that maybe I can identify if something has a predictable trend and generate an equation for prediction as well.