I think what you'll need to do is drive these sheet by a parameter, not a filter.
Hang on. I'm hacking up something.
In the attached I changed the Segment filter to apply to only the first sheet. (Probably don't need it at all.)
I made sheet 3 to show me what segment any selected customer is. (AA-10315 is "Consumer", so that's what I want to show on the Segments sheet.)
On the segments sheet I edited the segments filter and selected the "Condition" tab. on there I did a formula:
sum( if [Customer ID] = [Customer Parameter] then 1 else 0 end) > 0
This says (for every row) if the customer field = the customer parameter, then 1. Then for any segment, if the sum of all those 1s is greater than zero, grab that segment.
So if you drive your Customer sheet with the parameter too, then one selection will do both sheets.
Dashboard Filter Actions A.twbx 411.1 KB
1 of 1 people found this helpful
What about a simple LOD expression?
For the lower graph, I used the Filters for Customer ID and Segment (same as the first), Column = ATTR(TotalSegmentSales), Row = Segment.
Sounds like that would work too, Michael.
If they need more than just one measure, they would need an LOD for each one, but that's a nice way to do it. No need for the parameter then.
Thank you to everyone who responded! And so quickly! Each of your suggestions allowed me to try out various solutions and I found them all helpful for other scenarios I am working on, so I've bookmarked them :-)
Gerardo Varela your solution got me what I needed and then some. Thank you for reminding me to think about the order of operations in Tableau. Gets me every time.