Report filtering by creating a drop down menu options based on predetermined filter of report
Hello Service Cloud Community,
We are trying to make our reports a lot more user-friendly since most of the custom objects contain text fields which are hard to filter on. As a result, we are in the process of providing alternatives to the end users by making sure that they can have dynamic filters, which change over time as more information gets populated into the text field.
With that being said, we would like to figure out if there is an opportunity to filter a pre-existing report, and then assign the results of that report to a variable in a separate report, and use that variable as the basis to create a menu filter which is going to populate with additional options as the previously mentioned report grows, as more data gets added to that field.