Try using the Dimension Limits option. Open the properties window of your chart and go to the Dimension Limits tab. If that tab doesn't exist change the chart type to Straight Table. On the Dimension Limits tab click on the Response_Level_4 dimension. Then select Show only Largest 1 values. Also make sure the Show Others option is disabled.
See the below image for an example. The left table shows the sum of sales for every Product-SalesPerson combination, the table on the right only the top values per product:
Hello, I received an answer to this question and wanted to make sure that the right person got the credit.
So, thank you Daniel Rozental - with a minor adjustment this worked for the problem above.
if( yourexpression = max(total <User_Profile_ID_SourceDB, Ans_Percent>
aggr( yourexpression, User_Profile_ID_SourceDB, Response_Level_4)),