6 Replies Latest reply on Dec 13, 2016 5:25 AM by Shinichiro Murakami

# Prevent Fixed LOD function from being altered by filters

Hi!

I would like to calculate market shares of companies, but I am having an issue making the FIXED function keep being equal to actual total.

For instance, I would like to calculate a company's market share by Segment in Region 4 and in Group E. The formula I am using is the following, considering dimensions I would like to influence the total sales that should be used:

{ FIXED [Season],[Segment],[Region],[State],[Sub Region],[Group]:SUM([Sales])}

In the image below, it is possible to see that, when all companies are selected, this function equals indeed the total sales:

However, when I choose a company, these numbers that should remain fixed change (some remain the same). For instance, when selecting CompanyE:

This would prevent me from calculating an accurate market share of the company. Is there any way to maintain the numbers of fixed sales as they are in the first image?

I am attaching the workbook - my Tableau version is 9.3

Thanks!!

• ###### 1. Re: Prevent Fixed LOD function from being altered by filters

Find my approach as reference below and stored in attached workbook version 9.3

• ###### 2. Re: Prevent Fixed LOD function from being altered by filters

Hi Norbert,

Thank you very much for your response.

However, I want to combine info, for example considering total sales of Segment 4, in GroupE in Region 4, what would be market share of each company. Therefore I put more than one dimensions in my Fixed Sales calculated camp.

Is there any way to do this?

Regards

• ###### 3. Re: Prevent Fixed LOD function from being altered by filters

Here is my approach.

Because your data includes Null, Filtering Company is resulted in losing the frame work.

Instead, duplicate the data source and link only with fields in the table. But exclude "Company"

If you data has 0 on all the combination of the table, you initial approach should work.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 4. Re: Prevent Fixed LOD function from being altered by filters

Oke then it should be

{fixed Segment, Region, Group: sum(sales)}

• ###### 5. Re: Prevent Fixed LOD function from being altered by filters

Thank a lot Shinichiro!!

I believe this solves my issue.

Best regards,

• ###### 6. Re: Prevent Fixed LOD function from being altered by filters

You are welcome.

Could you mark my answer as correct.

Thank,s

Shin