This content has been marked as final. Show 3 replies
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 Region||Customer Region||Spend|
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,