See the attached approach
it will return this for example
you join the 2 data sets as shown
this is how to apply the condition
the cost per calc is this
the cacl cost is
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
cost to operate.twbx 85.1 KB
You need to establish a relationship on the building side that denotes which model each building is. You can do this from the data source end, or if the 'Bldg Name' field is a static list of values, you can create a Group from it.
Once you have that, you can use Data -> Edit Relationships to link Model and Building. Here is an article that may help you: https://onlinehelp.tableau.com/current/pro/desktop/en-us/filter_across_datasources.html
Thank you! This is exactly what I wanted. ^^
Thank you Shin! The "edit join calculation" thingy is new to me.