BookmarkSubscribeRSS Feed
Calcite | Level 5

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...


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.






Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 1 in conversation