Objective: I want users to be able to place the cursor on a line and be able to see current year actuals, current year budget, and last year actuals. This is easy until i get to the ratios.
There is a dashboard titled "Info!" with more details on my objective. I also have an example of how I want it to look.
I created 4 sheets with 4 different methods I've tried that failed. I also have an explanation for each one called "Explanation (A)" (B,C,&D) in the dimension. Just hit edit on them and I think they will be useful. I also grouped the related measures into folders for each sheet.