2 Replies Latest reply on Aug 7, 2018 1:37 PM by natun barosh

    need help with calulation

    natun barosh

      hello everyone,

       

      i have a question regarding some calculation i need to make in tableau and i don't know how to do it.

       

      i have variable which is called  "bank name"'  and contain all kind of active banks in israel. all my calculations regarding this variable made on CNT(Bank Name).

       

      i wish to make a new variable which sum several of the banks together under one name, and leave the others banks as is.

       

      for example:   this is what i have

      bank name# Branch
      leumi300
      poalim250

      masad

      30
      discont80
      mizrhi50

       

      this is what i want:

       

      bank name# Branch
      leumi300
      poalim250

      new bank (= masad+discont+mizrahi)

      160

       

      how do i do this?

       

      please help,

       

      best

       

      doron