I think the easiest way to deal with the Eastern or East issue is to standardize with a calculated field then use that in your Region Parameter filter.
In your Terminations data source create a field called New Region IF [Region] = 'East' THEN 'Eastern' ELSE [Region] END
Update your Region Parameter Calc to use the new field [Region Parameter]=[New Region] OR [Region Parameter]="All"
Try using RANK_DENSE([YTD Terminations] ) for ranking if you want ties included. Index isn't really the same as rank.
I'm not sure what Most Termed Position is but LODs might be worth looking into.
PS I would use East instead of Eastern as the standardized value but you'd need to update your parameter list if you do.
Please find the attached screenshot. I am also attaching the workbook but it is in the 9.3 version (can't help).
Data source - Open Positions
1. Calculated field Name - Region Parameter
[Region]=[Parameters].[Region Parameter] OR (if [Parameters].[Region Parameter]="All" then [Region] END)=[Region]
Data source - Terminations (Sample-Terminations)
1. Calculated field Name - Region Parameter Calc
[Region]=[Region Parameter] or (IF [Region Parameter]="All" then [Region] END)=[Region]
Please edit the filter conditions, you will get the desired output.
Thanks and Regards,
FilteringAcrossDataSources.twbx 41.1 KB
Thank you both so much! I was able to get each of your ideas to work as desired, thanks again.