3 Replies Latest reply on Oct 10, 2016 6:44 PM by Sasha Abramovich

    How can I group/pivot data in Tableau?

    Sasha Abramovich

      Suppose I have two columns:

      A | B 
      1 | 5
      1 | 6
      2 | 16
      3 | 7
      3 | 9

      I want to have the following pivot:

      A | B 
      1 | 6
      2 | 16
      3 | 9

      And perform AVG() or other functions on B to display the results. How can I do it please?

      Clarifying update: I am looking to run the function over the entire column B. For example: (6+16+9)/3=10.33