Hi David!

We should be able to accomplish this using an LOD calc.  I attached a revised copy of your workbook, hopefully I didn't misunderstand the desired end result

To start with, I removed the Action dimension you had on Columns for the Trend worksheet.  Next, I created a custom date, [Order Date (Month / Year)] because we will need to use that date value in the LOD calc.  Next, I used this formula for the LOD:

{ fixed [Order Date (Month / Year)] :

    AVG({ fixed [Order Date (Month / Year)], [State] :

        AVG([Profit]) }) }

For the Trend worksheet, I placed the above LOD calc onto Rows and made the view a Dual Axis and also synchronized the axes.  I then made some color formatting changes to make the individual state avg and the overall US avg contrast each other a bit for ease of viewing.  The end result gives us something like this when hovering over a state:

Hope this helps!  Let me know if you were hoping for something different though

Thanks David!