1 Reply Latest reply on Aug 8, 2018 11:04 AM by Joe Oppelt

# Percentage of Total using multiple dimensions in single view without using multiple sheets

Hi,

Can anyone hlep me in achieving the below tabular chart in tableau.

My requirement is to show absolute numbers and % of total together based on multiple dimension  in a single view.

Eg: For USA.

External hire is 83%.

formula : External /External +Internal   ( 1250/(1250+250))

Internal  hire is 17%.

formula : Internal  /External +Internal   ( 250/(1250+250))

Consultancy is 20%.

formula : Consultancy /Consultancy +Referral + Online Media ( 250/(400+600+250))

Referral is 32%.

formula : Referral /Consultancy +Referral + Online Media ( 400/(400+600+250))

Online Media is 48%.

formula : Online Media/Consultancy +Referral + Online Media ( 600/(400+600+250))

Female is 25%.

formula : Female/Female+Male ( 375/(1125+375))

Male   is 75%.

formula :  Male  /Female+Male  ( 1125/(1125+375)) Below is the screenshot of sample data. NOTE:: There are many other metrics similar hence i need the order to be exactly as is in the screenshot

Please help me achieve the above in tableau. Please find the workbook and data attached.

Thank You

• ###### 1. Re: Percentage of Total using multiple dimensions in single view without using multiple sheets

In the attached I did calcs for external and internal.  You can follow the model and do it for all the rest.

Formatting is another matter.  I didn't try to address that.