You might try creating a calculated field that will sum the measure values. Then you can put that field in the tooltip to show the total.
Thanks for the reply!
That's what I thought but haven't had any luck figuring out exactly how to do that.
Can you help me with an example?
Try this. I didn't format it to a percentage but it appears to be giving the right output. The downside to this calculation is that it is hardcoded to the measures in the view and not depending on the measure names filter. Depending on how you plan to use the viz this might not be good.
I can't tell exactly what type of data you are looking at here, but I keep thinking that perhaps what you should have is 1 measure where 1 to 7, 15 to 21, etc are fields within. Or perhaps a measure with a value that you then create bins or groups from. Then, you would be able to run an aggregation on the measure that would be affected by the data. So, it may be that tweaking the layout of your data would prove useful, but I can't be certain.
Hope that helps.