3 Replies Latest reply on Aug 14, 2015 5:05 AM by Rody Zakovich

Percentage Calculation

Ben Adam Aug 14, 2015 12:43 AM

Hi,

I have a table that shows headcount numbers by gender, contract type & full time or part time. These are all in columns. I would like to express these numbers a percentage of the total headcount number for each area:

For example: if total headcount for area A is 100 and total number of male, permanent, full time staff is 10, then % is 10%

Hope that makes sense .... any help?

Thanks,

1. Re: Percentage Calculation

Mayan M Aug 14, 2015 1:04 AM (in response to Ben Adam)

Hi Ben,
Depending on you case , this might be achieved by table calculations:
Percentage Options

If this does not work for you, the LOD expressions are another option.
Top 15 LOD Expressions | Tableau Software

Regards
Mayank
Like Show 0 Likes(0)

Actions
2. Re: Percentage Calculation

Ben Adam Aug 14, 2015 2:06 AM (in response to Mayan M)

Thanks for that Mayan,

Problem I'm having is that when I try using the table calculation options, the percentages do not add up to 100%?
I have used the option to express each value as a percentage of the total row but it doesn't seem to be working .... any ideas?
Like Show 0 Likes(0)

Actions
3. Re: Percentage Calculation

Rody Zakovich Aug 14, 2015 5:05 AM (in response to Ben Adam)

Hello Ben,

Can you provide an example workbook, or a screen shot of your Viz?

Getting the Most From the Tableau Forums

You most likely need to change the Compute Using to Pane Down. (I am assuming it has been defaulted to Table Down). If it isn't that, then you might need to change what the Window Calc is partitioning on. But I can't know that without seeing the ViZ Level of Detail.

Regards,
Rody
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Percentage Calculation

1. Re: Percentage Calculation

2. Re: Percentage Calculation

3. Re: Percentage Calculation

Actions

More Like This