Can we inquire as to whether or not the Excel file can be restructured? Tableau has an Excel plug-in that would fairly easily remedy the issue you are having. It would be better if your columns were dates as opposed to month values, but this is still doable.
If this is the only way to have a workable file I will make the request.
What is the plug-in? Can you point me to it please.
Thanks for your response Ben.
Instead of having a column for "Year" and the various months, I believe you'd just want one column with a "Date" field. Since
these are month/year dates, I believe you'd want something like 1/1/2011 for January of 2011. Then, "Sales" would be a separate column as well. So, something like:
Customer DATE Sales
Cust1 1/1/2011 $19,500
Cust1 2/1/2011 $20,000