7 Replies Latest reply on Jul 8, 2015 8:16 AM by jonathan.o'grady.0

    calculate the percentage difference between two colums that contains percentage values (from a quick table calculation)

    Markus Nosko

      Hi

       

      I have a challenge with Tableau that I hope any of you could help me out with. I have a data set with actual sales per item and forecasted sales per item. I'm interested in seeing a single item's sales in relation to the total sales, both actual and forecasted. This I can manage with a quick table calculation (see picture below). However, I would as well want to see the percentual difference between these two columns, but I can't find out how. The desired extra column is visible in green in the second picture.

       

      Any advice on how this could be arranged is greatly appreciated!

       

      Best regards

      Markus Nosko

       

      Capture.PNG.png

      Capture2.PNG.png