5 Replies Latest reply: Feb 15, 2017 5:44 AM by Sunny Talwar RSS

    Filter what to Sum

    Don Andress

      Hello.

       

      I have a source table data like below:

       

      NAME

      TYPEJANFEBMARAPRMAYJUNJUL
      name1type14824884672720588132
      name1type2231237216114122130120
      name1type306-15412618746
      name2type11420-119418220874
      name2type1141147126119116107102
      name2type159860458390184597
      name2type32392452245712962163
      name2type306-1556957530
      name3type2712-816423156145
      name3type2865871850203420248
      name3type2-84-79-996723176215

       

      In the import file I definited that first two columns are description.

      Now, I have created a table where in one column I listed Names, in other column I summarize months by Names.

       

      How to construct expression to summarize all months only with Type1 and Type2?