https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Visual-Analytics-Viya-4-Only-Display-value-if-count-distinct/m-p/885213#M17393 <P>Advice would probably be creating a specific report that only allows selection of a single customer but I'll put it out there just in case there is a creative solution. We have a report with a few bar charts showing sales figures by product category. Users can filter by country, customer, sales rep, period, etc...</P><P>&nbsp;</P><P>A user wants the report to display the name of the customer in a text field in the report only if filters applied returns a single customer (e.g. a single customer id is selected). As Text object only returns numeric fields or parameter variables, I was not able to use the Text object. However, I was able to use a list control and apply Rank of Top 1 to return the name of a single customer. This works well if a customer ID is selected and there is only a single account returned. However, there is no way I could use an aggregation (count distinct of customer id returned) in my Advanced Filter to only display the customer name if only a single customer is returned.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 18 Jul 2023 07:30:57 GMT dylanviking 2023-07-18T07:30:57Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Visual-Analytics-Viya-4-Only-Display-value-if-count-distinct/m-p/885213#M17393 <P>Advice would probably be creating a specific report that only allows selection of a single customer but I'll put it out there just in case there is a creative solution. We have a report with a few bar charts showing sales figures by product category. Users can filter by country, customer, sales rep, period, etc...</P><P>&nbsp;</P><P>A user wants the report to display the name of the customer in a text field in the report only if filters applied returns a single customer (e.g. a single customer id is selected). As Text object only returns numeric fields or parameter variables, I was not able to use the Text object. However, I was able to use a list control and apply Rank of Top 1 to return the name of a single customer. This works well if a customer ID is selected and there is only a single account returned. However, there is no way I could use an aggregation (count distinct of customer id returned) in my Advanced Filter to only display the customer name if only a single customer is returned.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 18 Jul 2023 07:30:57 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Visual-Analytics-Viya-4-Only-Display-value-if-count-distinct/m-p/885213#M17393 dylanviking 2023-07-18T07:30:57Z