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?

    Vimal Annamalai

      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?

       

      Please someone help me.