I'm having an issue getting Tableau to perform calculations as I'd like it to. As pictured, I'd like to display an average of "Period Lease Rent" by Floor Plan Name. However, I'd like RENT, HOUSING and SUBRENT to be treated as a combined sum rather than taking an average of those three individually.
In short, I'm curious about the average of the total of those three for a given Floor Plan in a given month. My attempts at creating calculated fields to get around this have been unsuccessful because Tableau continues to see 3 distinct data points rather than treating them as a single total.