Thanks Abhay. The Filter 1 still shows the results for all records, rather than the filtered subset.
1. Click Customer Name "Emily Phan"
2. Then try to view the detail for Sub-Category "Art"
3. The desired result would be to see 4 records on the detail, but you see all "Art".
You would have to first click on the Customer name and then click on the 'Filter-1" to go to the detailed sheet with filtered records. Alternatively you can use a 'Run On" option of Select or Hover instead of Menu to change the behavior. Let me know if this does not help.
When I click on the customer name in the Customer view, then click on Art in the Sub-Category View, and click Filter 1, the result is 731 rows, not 4.
Ok. So it seems that if we keep the detail worksheet in the same dashboard the result gets filtered on expected lines.However if the detail sheet is in a different sheet/dashboard altogether then somehow tableau does not keep track of the previous selection.
Any chance the detailed worksheet can be used in the same dashboard as a workaround.