5 Replies Latest reply on Jan 25, 2018 2:48 AM by Ruchika R

    Calculation from a table

    Ana Otalvaro

      Hi,

      I am trying to group certain categories in a table. I have done a classification by sector showing their respective market weight like this:

       

      Retail 5%

      Healthcare 2%

      Industrial 1%

      Utilities 0.5%

      Automobile 0.2%

       

      I would like to create a calculation field in order to group all those sectors with a weght <0% as "Others". Does anyone know how to do this? My weights may change depending on the date i select so need this to be dynamic

       

      Thanks a lot