1 Reply Latest reply on Aug 28, 2015 12:54 AM by Mark Fraser

    Add and then divide in Tableau

    Ashish Choudhary


      Starting from the Data

          

      XYGrouping1Grouping2Grouping3
      23RealOLD1
      35RealNEW2
      47RealOLD2
      37RealNEW3
      56RealOLD3
      1117FakeNEW4
      1319FakeOLD4
      2955FakeNEW5
      2550FakeOLD5
      3055FakeNEW5

       

       

      I am hoping to plot the values sum(X)/sum(Y) for all distinct values of Grouping 3. Basically

      Rowlabels vs Results in the table below

       

         

      Row LabelsSum of XSum of YResult
      1230.67
      27120.58
      38130.62
      424360.67
      5841600.53

       

      The graph should only have 5 points. How do I do this in tableau. (I do not want to do a pivot in excel!)