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

    Calculation from a table

    Ana Otalvaro


      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