10 Replies Latest reply on Jan 21, 2019 1:58 PM by Scott Schmeling

    How to use a value from one member in another members calc

    Scott Schmeling

      Good Morning,

       

      Does anyone know a way to use a value from one member in another members Calculation.

       

      For Example- I have 2 locations: A and B

       

      Within those locations we create a calculation to be Member Day Rate (MBR:

       

           Member Day Rate = (Member Days / Membership) *1000

       

      For Location A-

       

           I have a member day Rate of 168 (Calculated in Tableau)

           I have Member Days of 37361

           Membership of 221,191

       

      Location B-

           I have a membership of 147086   

       

      I want to be able to figure out how many member days I would need in location B to get the same Member Day Rate:

       

           Formula would be

                (Location A's MBR / 1000) * Location B's Membership

       

      Any suggestions on how to store the MBR of Location A and use it in a calculation with Locations B's Membership would be very helpful.

       

      We are using Tableau 10.5

       

      Thank you.