1 of 1 people found this helpful
Hello Jason Alexandre,
The data in this workbook is somewhat challenging to work with in this format. I suggest reading through this document: Preparing Excel Files for Analysis | Tableau Software
Note that version 9.0 of Tableau (not yet released) has a 'pivot' tool built into the product for managing this sort of Excel formatted data directly in Tableau. You may wish to test the Beta or wait until the release since the new version makes this much easier to work with.
If time is short though, the methods described in the knowledge base article may be used in conjunction with the Data Reshaping tool to get going.
Thanks Patrick - I think I was able to figure it out by creating calculated fields and coding the numbers using the Attribute function. It seems to have done that job. That said, the article you sent on re-shaping and the Tableau Add-On for Excel may help me with another problem.
Did you manage to create the dashboard in Tableau as im trying to achieve something similar.