Currently (as of 8.0) we can have filters on aggregate work across N worksheets from one data source, but they cannot be used as Filter Actions. I'd like to be able to apply filters on aggregate measures within Filter Actions across data sources. I know computing the domain of these filters could get tricky, at the least I'd love to see boolean aggregates and others with a fixed domain (like a worse/better/best KPI) supported.
This is a variation of http://community.tableausoftware.com/ideas/1314.
As pointed out by Kris Erickson below, it turns out that Filter Actions do work when an aggregate measure is specifically selected as the origin, so this Idea is more specifically focused on supporting aggregate measure results as the target of a Filter Action.