2 Replies Latest reply on Jul 30, 2018 7:15 AM by Mavis Liu

# How to create new calculated field on Dimension value

Hello,

I have one column KPI list and second column - KPI value. I need to create new KPI (calculated field, based on current KPIs).

For example - in current KPI column is "Total number of FTEs" and "FTEs in group A" and "FTEs in group B" and I need to calculate percentage (group A/total, group B/total)..

I tried something, but it didn't work

Thanks,

Helena

Source

 Department KPI Value 1 FTE 150 1 FTE group A 50 1 FTE group B 100 2 FTE 200 2 FTE group A 50 2 FTE group B 150

Goal:

 FTEs by groups: department 1 group A 33,33% group B 66,67% department 2 group A 25,00% group B 75,00%
• ###### 1. Re: How to create new calculated field on Dimension value

Hi, Helena

Please find my solution attached as well as below screenshot for reference.

Hope this helps

ZZ

• ###### 2. Re: How to create new calculated field on Dimension value

Hi Helena,

You can use table calculations to find the % of total.

First I Filtered out KPI = FTE as this is not needed. The I right clicked on the Sum value and selected the quick table calculations - Percent of Total:

By default,tableau may calculate the % of total for the whole. Right click on Sum value again and edit the table calculation to be calculated pane down. This way you're working out the percent of total per department:

Final result should look like this:

Please see the attached workbook for the example.

Thanks,

Mavis