I have attached a zip file containing an excel with Raw data and the expected calculation to show the final score (I have highlighted it in yellow on the Scores sheet).
I can do the calc in a minute in SQL (a very simplified SQL query is also attached as a txt file) but unable to find any way in Tableau since last many hours.
Any help will be highly appreciated!
No worries I found the answer here ...http://kb.tableau.com/articles/knowledgebase/calculating-weighted-averages
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...