Hope this helps.
One more data re-shaping helps a bit.
Then put the Pivot Table Value to measure in row.
Then add table calculation as below.
Quintile_SM_10.1.twbx 26.3 KB
This was precisely what I needed. Thank you very much for your help, I greatly appreciate it.
I am very new to Tableau and figuring stuff out by yourself can sometimes be a challenge!
Again, many thanks.
You are welcome and welcome to Tableau world and community.
This community is the one of the best place to learn Tableau's trick, hacks.
Hope you enjoy the community.