3 Replies Latest reply on Jun 23, 2018 9:56 PM by Mahfooj Khan

    Calculate leakage Percentage in Tableau

    Madhup Modi

      Hi guys,

       

      I am struggling to do something very trivial in Tableau. I have the Transaction data at merchant - customer area level. I want to calculate leakage for all merchant regions.

       

      Merchant RegionCustomer RegionSpend
      AA62
      AB26
      AC46
      BA61
      BB81
      BC70
      CA25
      CB44
      CC26

       

      This is how my data looks like. Leakage for Region A would be spend done by customer outside Region A. Calculation = (26+46)/(62+26+46). Similarly, for Region B would be (61+70)/(61+81+70). This calculation needs to be dynamic. I could have multiple merchant and customer regions. Please help. I have attached my packaged workbook for reference. I am using Tableau 2018.1 currently

       

      Thanks in advance,

      Madhup