3 Replies Latest reply on Mar 9, 2017 8:39 AM by Ashvin Khole

    Issue with getting % of total calculation

    Ashvin Khole

      New to Tableau here, using v10.

      I am trying to get the following answer in the attached workbook. I essentially want 2 more columns such that:

      column 1 should give me the % of "profit" in "close" to "profit" in "grand total" for each region. so for e.g. for east this would be = 0/300 = 0% and for north it would be 100/100 = 100%

      column 2 should give me similar calculations for the variable "trxn"

       

      I am trying to do this using LOD calcs but I think the issue is "close", "open" and "renovate" are not actual dimensions but they are values of dimensions.

       

      Any help would be appreciated.