So I first created a dimension for Won or Opportunity like this....
[OpportunityID - Level]
IF [Phase] <> 'Won' THEN 'Opportunity' ELSE 'Won' END
I brought this into the level of detail for each of the 2 KPI sheets (so we can access this dimension in the action) and then set up the action like this (I've used a Menu action, but you can change to click)
Hope that helps
Feasibility Test_SR.twbx 49.0 KB