1 2 Previous Next 19 Replies Latest reply on Oct 25, 2016 1:08 AM by Simon Runc

    Show Difference for various measures in a new column

    Henry H

      I have the following data:

           

      DateLocationItemPriceCostSold
      1/1/2016USAItem 1$10 $3 $20
      1/1/2016USAItem 2$20 $10 $20
      1/1/2016USAItem 3$30 $15 $20
      1/1/2016EuropeItem 1$2 $2 $20
      1/1/2016EuropeItem 2$5 $5 $20
      2/1/2016USAItem 1$9 $7 $20
      2/1/2016USAItem 2$7 $5 $20
      2/1/2016USAItem 3$5 $4 $20
      2/1/2016EuropeItem 1$2 $2 $20
      2/1/2016EuropeItem 2$5 $5 $20
      3/1/2016USAItem 1$1 $1 $1
      3/1/2016USAItem 2$1 $1 $1
      3/1/2016USAItem 3$1 $1 $1
      3/1/2016EuropeItem 1$1 $1 $1
      3/1/2016EuropeItem 2$1 $1 $1

       

       

      I would like to show a Tableau table looking exactly like this:

             

      2/1/20161/1/2016Difference
      Price$60 $21 $39
      Cost$28 $16 $12
      Sold$60 $60 $0

       

      The issue is I can't get the difference column to show up on the same worksheet.  I understand I can create two worksheets, one showing the data, and one showing the differences, and showing them together in a dashboard.  But is there any ways to get them on the same worksheet?

       

      I've attached the workbook.  Feel free to download and please let me know of any solutions.  Thanks in advance and much appreciated!

        1 2 Previous Next