1 Reply Latest reply on Jun 15, 2018 12:38 PM by Shinichiro Murakami

    Displaying title using if statements

    Krishna Dudhela

      Hi I am trying to display a dynamic title based on the filter we select.

       

      Given: 2 Filters

      1.Region Filter (containing values-NCA,SCA)

      2.Brokered/Direct Filter (containing values-Brokered,Direct)

       

      Requirement:

       

      If we select the given filters then it must display following results.

       

      Filter

      Region

      Filter

      Brokered/Direct

      Result
      NCABrokeredNCA Brokered
      NCADirectNCA Direct
      SCABrokeredSCA Brokered
      SCADirectSCA Direct
      NCA, SCABrokeredCABrokered
      NCA, SCADirectCA Direct
      NCABrokered,DirectNCA All
      SCABrokered, DirectSCA All
      NCA,SCABrokered,DirectAll

       

       

      I used below if statements.

       

      My calculations aren't displaying properly.

       

       

      Can anybody help me correct my calculation?

       

       

      Attached workbook.

       

       

      Thanks,

      Krish.