Do you know about calculated fields?
You can use a Calculated field, which is accessed by right-click on the measures and then in the calculated field call the columns that you want to perform calculations and prefix and suffix with appropriate function syntax. If you try and still don't understand, pl. come back.
I took this path to answer you as you seems to be familiar with ms-excel, so, I want to make sure that you understand one of the powerful feature of Tableau 'calculated field'
All the best,
Thanks for helping me.
I know about calculated fields - but I do not know have to call each column to calculate between them.
In excel it would be something like: =(B4+C4+D4)*E4/F4
I couldn't get much time as of now, but you try to tweak from what I did, I believe there is a little syntax and application of calc. changes needed to see what you desire.
I hope either you or someone can take a look further and get this.
Case_131113_MuraliGovindu.twbx 42.4 KB
Whauu - a lot of work you have done.
I'll try to see if I can figure out how to finish it.
Maybe somebody can help?