10 Replies Latest reply on May 4, 2018 6:59 AM by Kaul Smith

# Calculated Field

Hello,

Out of five factors I like to sum up marketing, Misc, Other and Sales as together which is 185,500 and use this value to divide with total amt : 185,500/190,500 which will be 97.38%

Can anyone please help me on this to do in the tableau?

I attached the workbook.

• ###### 2. Re: Calculated Field

Thanks for the response, Deepak.

In the above screen shot, I mentioned only for one company but In my workbook there are lot companies.

So when I filter for different company to get percentage its using the same total amt 1 (185,000)  for every company.

Can I make dynamic so that it uses total amt according to the company?

• ###### 3. Re: Calculated Field

Can you explain ?

• ###### 4. Re: Calculated Field

Ok I got it. Just drag your Company to Filter and add it to CONTEXT

• ###### 5. Re: Calculated Field

Hello Deepak,

If I select only one company the percentages are correct but if select multiple companies or region and corporate the percentages are changing.

I like to show the exact percentages even after the multiple filters are applied.

I attached the workbook.

Thank you for your help!

• ###### 6. Re: Calculated Field

What is meant by this?

• ###### 7. Re: Calculated Field

Sorry for the confusion, when I select multiple filters instead of calculating from grand total I like to calculate each company total individually. Please see below for more details.

Please see the attached workbook where I made few tabs.

In this screen shot, For company F1, 92.13% and 61.11% for Profit and sales.

But when I select F1 and F5, the percentages are changing because the profit and sales percentages formula is calculating from grand total instead of  individual company's total.

So, Finally I am expecting to display like this, in below screen shot the profit and sales percentages are calculating using company's total instead of grand total.

• ###### 8. Re: Calculated Field

Can you save your attachment as 10.4 from File menu and reattach.

• ###### 9. Re: Calculated Field

Deepak,

Here is the 10.4 version, please let me know if it doesn't work.

Thank you

• ###### 10. Re: Calculated Field

Hello Deepak,

Do you have any thoughts on this??