Forcing SAP Webi report to show specific data

This can be done by creating a separate query that only shows priority. Then you need to replace column [Query1].[Priority] with the merged dimension [Priority].