I noticed that you are using bit older version of tableau (that has nothing to do with the problem that you are facing), thus you won't be able to open the workbook which I am sharing here.
Kindly follow the below steps.
Please refer to the screenshot below to prepare your output. Kindly exclude the Total from the Label dimension as you can calculate the total in this tool. (You can see I have excluded the totals.)
Put actual values and not the formula that you have written. Put values again to the row section and right click, go to table calculations and select percentage of total and select direction as table down. Refer below screenshot for the same.
For Totals go to analysis section, go to Totals and select "Show column Grand Total" option. Refer below image.
This will take care of everything. Let me know if this helps.
Thanks and Regards,
1 of 1 people found this helpful
Thank you! This does the trick.