5 Replies Latest reply on Apr 15, 2018 11:22 AM by Vimal Annamalai

# I have 8 filters & 2 columns, How to tell the worksheet, only 3 filters applicable for A column & Other 3 filters applicable for B column then remaining 2 filters common for both A & B columns?

I have two columns A & B and having 8 filters in a worksheet.

My requirement is:-

How to tell the worksheet, only 3 filters applicable for A column & Other 3 filters applicable for B column and remaining 2 filters common for both A & B columns.?

Below are the 8 filters:-

Filters

1) TestName

2) ModelName

1st set Filters :-

Branch 1

Build 1

TestDate 1

2nd set Filters :-

Branch 2

Build 2

TestDate 2

I know this can be done with parameters and created a two calculated field with below formula.

Col A_ Calculated Field:-

{ FIXED [IntervalId] : MAX(

IF ([TestName] = [TestName Parameter] and [Model] = [Model Parameter] and [Branch] = [Branch 1] and [Build] = [Build 1] and [TestDate] = [TestDate 1] ) THEN

[ActiveIOType]

END)

}

Col B_ Calculated Field:-

{ FIXED [IntervalId] : MAX(

IF ([TestName] = [TestName Parameter] and [Model] = [Model Parameter] and [Branch] = [Branch 2] and [Build] = [Build 2] and [TestDate] = [TestDate 2] ) THEN

[ActiveIOType]

END)

}

But how can i achieve this with Filters?

• ###### 1. Re: I have 8 filters & 2 columns, How to tell the worksheet, only 3 filters applicable for A column & Other 3 filters applicable for B column then remaining 2 filters common for both A & B columns?

Do you "need" it all on one worksheet?  You could create two worksheets that you line up next to each other on the dashboard and for the two filters you want to affect both apply to multiple worksheets.

-Hope

• ###### 2. Re: I have 8 filters & 2 columns, How to tell the worksheet, only 3 filters applicable for A column & Other 3 filters applicable for B column then remaining 2 filters common for both A & B columns?

Right, Hope.  Tableau treats the whole sheet uniformly.  A filter applies to the whole thing.

Separate sheets.

The other thing to do is to have the column values controlled by parameters.  You can create a calc for one column that takes Parameter-1 into account, and another calc for column-2 that takes parameter-2 into account...  But if the filters are supposed to be multi-select, the parameter idea isn't workable.

• ###### 3. Re: I have 8 filters & 2 columns, How to tell the worksheet, only 3 filters applicable for A column & Other 3 filters applicable for B column then remaining 2 filters common for both A & B columns?

@Hope Stiles & @Joe Opplet,

Thank you so much for the suggestions. Yes, I have done the both possible ways as you mentioned, 1)Creating Parameters and apply the calculations 2) Split into two different sheets.

The ways I mentioned above is not letting me to achieve my below requirements at the same time.

I'm doing the comparison dashboard. So, Below are part of my requirements :-

2) Calculate the percentage difference between col A & Col B

My Bottleneck:-

1) If I split the sheets cascading the filters is working but i can't achieve percentage difference.

2) If I apply the parameter way, I can't cascade it but percentage difference is possible in this approach.

So, That's why i asked this questions. I will be so happy if i achieve my both requirements in any possible ways.

Your suggestion or help will be much appreciated.

• ###### 4. Re: I have 8 filters & 2 columns, How to tell the worksheet, only 3 filters applicable for A column & Other 3 filters applicable for B column then remaining 2 filters common for both A & B columns?

You might have conflicting requirements here.

I'd like to take a stab at what you have.  Can you work up a sample of your data and sheets and upload a packaged workbook?

• ###### 5. Re: I have 8 filters & 2 columns, How to tell the worksheet, only 3 filters applicable for A column & Other 3 filters applicable for B column then remaining 2 filters common for both A & B columns?

Sure, Joe Oppelt.

Let me ready my sample workbooks & get back to you quickly. Give me some time