6 Replies Latest reply on Nov 27, 2018 4:06 PM by Deepak Rai

    Calculated Field for the below scenario

    Ramesh Ravichandran

      For example, I have the data for the column "Accounts". I would like to create a calculated field which should group the values A,B,C,D,E to total market and C,D,E to Planned market. Basically i would like to show two values in the filter which has "Total Market" (all the values from the "Accounts" column should consider) and "Planned Market" (only subset of the values).

       

       

      Accounts
      A
      B
      C
      D
      E