Welcome to TAbleau and the forum
please see the site below and the block of required readings
Your data from excel should be cleaned so that it is just columns c-h
then loaded in tableau and pivoted - Pivot Data from Columns to Rows
then use a simple calculated field to get your results
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi David, please use this calculation:
Please see attached. However Jim is right, you should clean up the data. You might be able to use the data interpreter to help, this can be found in the data connection window.
percentage 9_v10.2_v10.2.twbx 701.6 KB