I have some data which shows sales for each account throughout the year. I want to create a trendline to be able to project how much sales will I get in the next 6 months on the basis of the past data.
However, I am unable to do it in Tableau as everytime I try to create a trendline it says atleast one axis should be a date. I am attaching the screenshot of the data for the reference here.
The column heads have the months and then each row represents sales for each account across different months. Can I create the trendline chart for this data in Tableau.