2 Replies Latest reply on Feb 12, 2016 10:38 AM by Wing Nguyen

    How to subtract column data from Grand Total

    Wing Nguyen

      Hi, I want to add a calculated field to subtract the Grand Total of each year from the available items each month. So end result I want it to look like the grid below. Can you guide me on how to do this in Tableau desktop 9.2? Workbook attached.

       

      Thanks

      Wing

       

       

      20152016
      Grand Total615
      Feb614
      March611
      April57
      May45
      June34
      August33
      September31
      October30
      December00