Hi Guys,
I have a use case where I need to add a filter in the visualization such that its corresponding member elements are always shown in a table on the report. However, when I select a particular combination of elements in the filter, it should filter the table visualization with selected elements having non-null values. For other elements, it should show whatever data present at the back-end i.e. if null then blanks otherwise corresponding values
Thanks in advance
1 answer
Hi Manish,
Not sure if this is what you're looking for but it sounds like if you click the drop down on the filter and select:
Only Relevant Values
for each of your filters it should do the trick.
