BookmarkSubscribeRSS Feed
dylanviking
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.

 

 

 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


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
  • 575 views
  • 0 likes
  • 1 in conversation