You wont be able to provide a drill down in the format you are trying to within the tooltip
the best way to do this is to have an additional sheet on the dashboard and use the first sheet as an action filter.
That is definitely really helpful and should solve Matthews problem.
Hi, thank you for all the suggestions. This post is helpful and in essence is what I'm trying to achieve. The only issue is the foundation for bar-charts in the tooltip is a map which by default has the data segmented. My underlying data is only a table (developed by someone else which I'm attempting to enhance...so it cannot be changed.) which I would like to provide a quick view breakdown without showing the breakdown initially in the table.
I followed all the steps in this post but when attempting to create the Calculated Fields, then insert them to the tooltip, they have to first exist on the initial table - which I don't want displayed.
I'll look further through the bar char option again to see if it can be modified to achieve my end goal.
Thanks for your help!