First, change all of your calculated fields that are currently used in the caption of the Title sheet to return an empty string if the count is > 1 or the attr of the field plus a space if there is only one selected. For example:
if COUNTD([Product1])>1 then "" else ATTR([Product1]) + " " end
Then create a calculated field that concatenates them all together. For example:
[APR Group1 Field] +
[Applicant Type1 field] +
[Customer Type1 field] +
[Decision Aliya1 field] +
[Decision Applicant DTI1 field] +
[Decision FICO1 field] +
Use that calculated field to display the selected filters - it won't contain any unnecessary white-space.
This works well when I have a single selection . But if I change my filters to multiple selection drop drown then this functionality is not working. Any suggestions on how I can achieve list of applied filters in case of multiple selection in any filter.
Thanks in advance!!
Unfortunately there is no way to get a list of selected items from a Quick Filter. You could display "Multiple Values" instead of a blank when more than one filter is selected, but that would also pick up "all" as "multiple values" which you don't want.
This might be over-complicated :-) but you could display the number of selections. To do this, first create a fixed calculation giving the number of each of your filter measures. For example:
Then, change the associated "field" calculation to this:
where it is comparing the number of selected items to the total number of items.