2 of 2 people found this helpful
Hi P Fro,
Currently, that condition filter box cannot be removed. It's a good one for the Ideas section.
You may be able to get the desired outcome with using a calculated field instead of the condition filter.
Hope this helps!
Thanks Tracy, at least I know for sure that I'm not just missing some option to remove them. I may go ahead and try the calculated field approach....thanks for that idea.
6 of 6 people found this helpful
Hi P Fro ,
This is one more good solution .
Right click on filter ->edited the height of the field and make it fixed height (say 60)
This keeps its condition hidden.
PS if you find this solution helpful ,please do mark helpful to encorage forum contributors
Awesome workaround Manisha. Just wanted to say thanks, I'm glad you put this out here.
1 of 1 people found this helpful
Hi P Fro,
Currently, the condition from condition filter box cannot be removed. But surely after doing below steps you can able to remove that condition.
To remove the condition follow below procedure:
Step 1: In your case apply the condition that you want as usual to 'HMS PreCounts$ '_BEFORE_SUPPRESSION
Step 2: Then Create Calculated Filed ---> and just put the dimension on which you applied condition in your case 'HMS PreCounts$ '_BEFORE_SUPPRESSION'
Step 3: Now simply put that calculated field in Filter Shelf and Show that Filter you see that the condition is removed.
Hurryyy you are done with the procedure
Thanks & Regards,
What I have done here is to create a calculated field (let's called this Year-without condition label) that reference to another field (let's called this Year) and added both of them in the Filter shelf. Apply the condition filter to the field (Year) then show the field (Year-without condition label) as a quick filter. You may refer to attached file as I know I suck at explaining myself . Let me know if that helps you.
sample workbook.twbx 1.2 MB
Thank You Ralph, the only issue now is how to sort this new filter. I am using it as a date and would like to have the most current show on top, however with the new filter, there is no sorting function. Another way I figure is to place a floating blank sheet on top of the wording, but that will only work if everything is fixed size and not on automatic sizing.
Thank you! This worked perfectly for hiding the ugly verbose filter condition I had from the filter pane!
The easiest way to fix it !Thx!