6 Replies Latest reply on Oct 19, 2016 2:12 PM by Daniel Kaplan

    Summing by unique usernames across months

    Daniel Kaplan

      Hello,

      I think this should be a pretty easy fix but I can't get it to work.

      I have three variables: username (unique identifier), no. of contacts (the value that I would like to sum) and month.

      It's in the following format:

      UsernameNo. of contactsMonth
      allycakes731August
      allycakes731August
      ryanimp1August
      ryanimp4September
      ryanimp3September
      sam.ansell3October
      sam.ansell1October
      sarahh_janee062October

       

      I would like to sum no. of contacts for each month, by the unique username. End result should look like this:

      UsernameNo. of contactsMonth
      allycakes732August
      ryanimp1August
      ryanimp7September
      sam.ansell4October
      sarahh_janee062October

       

      There are many more rows but I don't want to have to worry about summing in excel. I want to simply add another row and have tableau do the work.

       

      Any help would be great! Thank you!